Hi!
Wanted to share an experience I've had with Office 2007. I created a macro that processes a folder with Excel workbooks, selecting a specific sheet in each workbook, copying a range with integrated photos and charts, and finally pasting the image into a WORD document. When using Application.ScreenUpdating=False to speed up the process, the images are never included in the final paste image. The code works when I step through it with F8, but as soon as I run the macro the images get lost. There might be an issue with .xls and .xlsx files, since it's so far only .xls files that lose images, not .xlsx files.
We've had other problems with copy/paste a range with integrated images (charts or other images inside the copied range) as image and zooming with Excel 2007.
FYI Martin
Wanted to share an experience I've had with Office 2007. I created a macro that processes a folder with Excel workbooks, selecting a specific sheet in each workbook, copying a range with integrated photos and charts, and finally pasting the image into a WORD document. When using Application.ScreenUpdating=False to speed up the process, the images are never included in the final paste image. The code works when I step through it with F8, but as soon as I run the macro the images get lost. There might be an issue with .xls and .xlsx files, since it's so far only .xls files that lose images, not .xlsx files.
We've had other problems with copy/paste a range with integrated images (charts or other images inside the copied range) as image and zooming with Excel 2007.
FYI Martin