Hi!
I have developed a small application in Excel 2010. As I need to show in a separate form images of charts and a worksheet (I don’ want the worksheet to be editable at all), I save them as a picture file in meta (or png) format and then load in an image object on the form.
For the purpose I use a module, developed by Stephen Bullen, called “modPastePicture”.
This application works perfectly in Excel 2007 – 2010 and 2003 as well.
Yesterday I tested in Excel 2013, on a new 64 bit computer and it could not compile the code. The error message said in short “Your code is not compatible with 64-bit engines … redesign” and the error was on the Public Declare Function rows of this module and on the same some declarations of other modules where I use “foreign” functions.
Can anyone advise me how to avoid the functions (or the libraries ?), or how to make this compatible to 64-bit systems?
I am attaching the module as this is more important, the other modules I can redesign without the “foreign” functions.
Bookmarks