OK - I'll try asking this one again, since the solution provided works only
for Excel 2003, not for 2007.
I need to copy clipboard contents to a bitmap file using VBA in Excel.
The Leban's approach is nice for 2003, but doesn't help with 2007 (and I
imagine most people are going to shifting upwards in versions at some point).
The problem is that Excel 2007 has a different way of handling the
clipboard, hence at least a couple of the OLE commands simple don't work
anymore. Querries into clipboard availability are not effective nor are
extractions.
Please assist per 2007 - Thanks !