[Solved] VBA: copy string to clipbaord

  • 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.

  • 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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!