This should be a pretty simple question for anyone familiar with MSVB functions. I'm pretty good with them, but I just don't use it enough to know what this particular function is called...

The Question:
Is there a way to create a STRING in VB and then place it onto the copy/paste clipboard? For example, I run a macro that generates a string, and then the macro places the string onto the clipboard so that I can paste it wherever I want with Ctrl-V?

It would look something like this:

sub KineticsMacro()

Dim KineticsString As String
KineticsString = "Hello World"


end sub
Then when I press Ctrl-V, the string "Hello World" will paste into whatever document I have open.



And for those of you that require more information...

The situation:
I have a word document with about 50 CHECK boxes in it. The client takes this form, checks off the applicable boxes, and resubmits it to me. More often than not, 30 or more checkboxes will be checked. To dummy-proof the form (for the client & people on my team), the document is to remain in "Locked/Secure" mode at ALL TIMES, and each checkbox was created as a VB object so that macros could be assigned to them.

The problem:
When I get this form, I need to copy the information from the form into a database, including a list of everything that was checked. Unfortuneately, since the document is always Locked-down, you can only highlight/copy/paste text that resides in designated unprotected "free text" areas. Since we can't risk a client changing the text for each checkbox, we have no way of performing a copy/paste from the form into our database...
...and entering 30 or more sever names for every form that we get requires WAY too much of our time.This is from the VBA help file - remember to press F1 from within the VB editor:

Quote

Example
As it applies to the SELECTION object.

This example copies the contents of the selection into a new document.

If Selection.Type = wdSelectionNormal Then
Selection.Copy
Documents.Add.Content.Paste
End If

As it appllies to the BookMark object.

This example sets the Book2 bookmark to the location marked by the Book1 bookmark.

ActiveDocument.Bookmarks("Book1").Copy Name:="Book2"

As it applies to the Range object.

This example sets the Selection bookmark to the \Sel predefined bookmark in the active document.

ActiveDocument.Bookmarks("\Sel").Copy Name:="Selection"

This example copies the first paragraph in the active document and pastes it at the end of the document.

ActiveDocument.Paragraphs(1).Range.Copy
Set myRange = ActiveDocument.Range _
(Start:=ActiveDocument.Content.End - 1, _
End:=ActiveDocument.Content.End - 1)
myRange.Paste

This example copies the comments in the active document to the Clipboard.

If ActiveDocument.Comments.Count >= 1 Then
ActiveDocument.StoryRanges(wdCommentsStory).Copy
End If