Copy a string to paste into another program

[HansJ]

Is there an easy simple way to copy a string value in the line of code to paste into a different program? I have found several different ways but it sure looks convoluted...
Something as simple as
Dim strWhere as String
strWHere ="This is the text I need to copy"
??? How would I call this string and pass it off to the DoCmd?


DoCmd.RunCommand acCmdCopy

[ranman256]

its not an access command but a windows command:
clipboard.SetText strWhere
clipboard.PutInClipboard

[HansJ]

ranman I tried that and get a runtime 91 error on line clipboard.SetText strWhere

Private Sub Command100_Click()
Dim strWhere As String
Dim clipboard As Object
strWhere = "This is what I want"
clipboard.SetText strWhere
clipboard.PutInClipboard

[Micron]

Dim clipboard As MSForms.DataObject
Set clipboard = New MSForms.DataObject
clipboard.SetText "A string value"
clipboard.PutInClipboard

And you need a reference to the Forms (2.0?) library.
The alternative is an API call, but I presume that's what you meant by 'convoluted'.