View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TCook TCook is offline
external usenet poster
 
Posts: 22
Default Reading the Clipboard Source Information

Hey All,

Apparently Microsoft recently changed the way some of their Clipboard APIs
and associated Clipboard Formats work.

In the past, one could have Excel spreadsheet data on the clipboard and when
querying the clipboard, it would return "Microsoft Excel Worksheet" within
source information retrieved. Now, that key phrase is missing.

The above said, what I need to do is as follows:

Open an Excel file and put some spreadsheet data on the clipboard, go to
another Office Suite application, choose Edit PasteSpecial, and notice
that the phrase "Source: Microsoft Excel Worksheet". It is this data that
I need to retrieve.

Thanks & Regards,

TC