Paste Plain Text

[frank]

Thanks Gintara,

Didn't work. Strange thing.

What works manually:
Go into edit of an excel cell, copy the plain text directly, paste, and search works.
Copy the entire cell, paste into text editor (or notepad), copy from text editor, paste and search works.

Mimicking this in a macro performs exactly the same only when paste occurs nothing is found

I used

Code:

Copy      Help

key "FRS57"

(FRS57 being the search term) and that worked - but I can't hard code this, I need to pull from clipboard.

This is my simple code:

Code:

Copy      Help

;int w1=act(win("UltraEdit-32 - [Edit4*]" "Afx:00400000:8:00010013:00000000:*""" 0x800))
;'Cv
;'SH Cx

if win("Valogix Planner" "OMain")
,act win("Valogix Planner" "OMain")
,'Cf
,str s
,s.getclip ;;gets clipboard text, only plain
,s.setclip ;;sets clipboard text
,;key "FRS57"
,
,'Cv

I can't understand why it treats clipboard contents delivered by QM differently than manually.