I have a macro which changes a few variables in the input sheet and refreshes the file. Then, for each sheet, it copies the output print area and does a paste-special (enhanced metafile) on to a powerpoint. This process is repeated 85 times producing 85 different powerpoints from the same excel file.
This macro worked fine as long I was using office 2003. Recently, I migrated to office 2007. There were a few minor changes that had to be made to the macro and it started working fine.
Except that there is a small hitch. While doing the paste step onto the powerpoint, somehow the process is not completed. The slide is blank. The macro however continues running without any VB error. So, although I now 85 different presentations ready, some random slides are blank.
The trouble is that there is no pattern to it. It happens with one set of variables once but on repeating the process, there is no issue.
If I put my cursor on the slide, for a brief moment whenever the issue occurs, I get a message like "image cannot be displayed due to shortage of memory" though not in exact words.
Any solutions, please.
Thanks and Regards,
ssrsp.
Bookmarks