[RESOLVED] Pass the clipboard value to a variable

[Erroneous]

Hello everyone.

How can i pass the value of the clipboard to many variables?
I'm doing a sendkeys app like this one.

SendKeys "{TAB}"
SendKeys "{TAB}"
SendKeys "^{C}"

the next thing i want to do is to put the value of the clipboard to a variable and then populate it on my app once. i don't want to do a "copy-switchapp-then paste" thing. I want to pass the values to say 5 string variables and then once i switch back to my app i will paste all the values in a textbox.

Any help is greatly appreciated.

[RhinoBull]

You can use Clipboard object:

myStringVariable = Clipboard.GetText(vbCFText) 'or vbCFRTF

[Erroneous]

Perfect. Worked like a charm. Thanks.

[RhinoBull]

You are wellcome.