[Solved] VBA: copy string to clipbaord

blackie · Sep 7th 2003

What I've done so far Is to put an array together by taking cell entries and tagging them together, what I'm strugging on is copying my string array to the clipboard, so that I can paste my string into a 'non windows' app using the sendkey command

Any Takers ?

Cheers In Advance.
Alan

rem1224 · Sep 8th 2003

Hi Alan,

If you're using Excel 2000 or XP, the VBA has funcitons to read from and write to the clipboard.
PutInClipboard Method
GetFromClipboard Method

The VBA help text has some good examples.

.....Ralph

blackie · Sep 8th 2003

Thanks, I guess it was a case of not knowing the correct terms.

[Solved] VBA: copy string to clipbaord

Participate now!

Share