B
Brian T.
I recently upgraded from Excel 2003 to Excel 2007. I have a workbook that
has a bunch of macros set up to take snap shots of a certain range of cells.
For example:
Sheets("RT Recap").Range("Q80:X110").Select
SaveName = "\\Directory\" & Sheets("Charts").Range("stringdate").Value &
"file_name"
Call GIF_Snapshot(SaveName)
This would take a snapshot of whatever was in the cell range Q80 to X110,
save it to a specific directory, append a date to the beginning, and save it
as a .gif.
When using this in 2003, the image size is retained to be exactly how large
it is in the workbook. In 2007, it shrinks the image to a thumbnail.
Is there a setting somewhere that will tell Excel to retain the original
size of the cell range?
Thank you.
has a bunch of macros set up to take snap shots of a certain range of cells.
For example:
Sheets("RT Recap").Range("Q80:X110").Select
SaveName = "\\Directory\" & Sheets("Charts").Range("stringdate").Value &
"file_name"
Call GIF_Snapshot(SaveName)
This would take a snapshot of whatever was in the cell range Q80 to X110,
save it to a specific directory, append a date to the beginning, and save it
as a .gif.
When using this in 2003, the image size is retained to be exactly how large
it is in the workbook. In 2007, it shrinks the image to a thumbnail.
Is there a setting somewhere that will tell Excel to retain the original
size of the cell range?
Thank you.