View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rock Rock is offline
external usenet poster
 
Posts: 6
Default Run macro in Excel when new data is on the clipboard

I would like to have a macro in excel run when an application puts
data into the clipboard. I have a program that outputs data by
copying it to the clipboard, but there are hundreds of pieces of data
to collect using this method. I would like to streamline the process
by having excel watch for data on the clip board and then take some
action to place it on the worksheet in the proper location.

Is this possible and if so how is it done?

Thanks,

Rock