Copy data to the clipboard

[MaheshM]

Hi to all,

I'll be grateful if any body could suggest me VBA code for MSACCESS2010 that will copy the data to office clipboard from another program's window that is already running. eg. data from a market watch of a trading terminal window.

[orange]

You might want to look at this
http://allenbrowne.com/func-07b.html

[MaheshM]

Thanks for quick help, can you please elaborate, where to specify the program window, in the code given, from which the data is to be copied?

[Aussiebear]

Have a good read of this code by Allen Browne (very talented Aussie)

http://www.everythingaccess.com/tutorials.asp?ID=Copying-data-to-and-from-the-Clipboard-%28Acc-1-2%29