Putting Clipboard Contents into an Array

T

Thomas M

Word 2000

I have a document that I use at work that functions as a hot plate for
data. The document starts and end every shift as an empty document. I'm
writing a macro that will execute each time I paste text into the
document. Before the text gets pasted, I want to store it as a value in
an array. I've Dimmed the array for 100 values, although it's unlikely
that more than 20 would ever be used. The first time I paste to the
document, the contents of the clipboard should be stored as Locates(1),
the second time it will be stored as Locates(2), etc.

I've got everything in place except the command that actually moves the
text from the clipboard into the array. I can do it if I paste to the
document, then select the text and store it in the array, but it would be
more elegant if the text could go straight from the clipboard to the
array without that intermediate step.

Is there a way to do this?

--Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top