Panda
09-08-2012, 06:54 AM
Hi All,
Some time ago I posted here asking if someone knew of a way to export a range within a worksheet as a .bmp image. Thankfully someone got back to me and the I managed to implement the code on the worksheet and everything has been working fine since.
However my work are now in the process of upgrading both the OS (from XP to Windows 7) and MS Office (from 2003 to 2010), I have been testing the spreadsheet to see if it is affected and everytime I run the code on the newer Windows 7 system I get a 'Run time error 7, out of memory' message and excel just shuts down.
I have attached a copy of the worksheet and the code that I am having the issue with. When I step through the code it seems to hang up on;
'\\ Create the Range Picture Object
OleCreatePictureIndirect uPicinfo, IID_IDispatch, True, IPic
So in Summary;
Spreadsheet created using Windows XP and Excel 2003 = Works fine
Run spreadsheet using Windows 7 and Excel 2010 = Run Time Error 7
Run spreadsheet using Windows 7 and Excel 2003 = Run Time Error 7
Does anyone have any ideas?
Thanks
Panda
Some time ago I posted here asking if someone knew of a way to export a range within a worksheet as a .bmp image. Thankfully someone got back to me and the I managed to implement the code on the worksheet and everything has been working fine since.
However my work are now in the process of upgrading both the OS (from XP to Windows 7) and MS Office (from 2003 to 2010), I have been testing the spreadsheet to see if it is affected and everytime I run the code on the newer Windows 7 system I get a 'Run time error 7, out of memory' message and excel just shuts down.
I have attached a copy of the worksheet and the code that I am having the issue with. When I step through the code it seems to hang up on;
'\\ Create the Range Picture Object
OleCreatePictureIndirect uPicinfo, IID_IDispatch, True, IPic
So in Summary;
Spreadsheet created using Windows XP and Excel 2003 = Works fine
Run spreadsheet using Windows 7 and Excel 2010 = Run Time Error 7
Run spreadsheet using Windows 7 and Excel 2003 = Run Time Error 7
Does anyone have any ideas?
Thanks
Panda