Two questions:
How can I copy text from the clipboard to a string variable.
Where should I have looked to find this info?
Many thanks!
I've not done this, but looking at VBA HELP for "clipboard", it seems to me
that I would rephrase your problem as being "How can I assign test to a string
variable". And the answer would then relate to the source of the text.
I think you have to put the information someplace before you can put it into a
string variable.
For example (given some data on the clipboard):
==========================
Option Explicit
Sub foo()
'get information from clipboard into string variable
Dim s As String
ActiveSheet.Paste Destination:=ActiveSheet.Range("a1")
s = [a1].Value
Debug.Print s
End Sub
===================
--ron