Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
when 2007 is installed side-by-side with 2003, open xls with 2003 | Setting up and Configuration of Excel | |||
2003 and 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 to 2007 | Excel Discussion (Misc queries) | |||
2007 & 2003 Excel | Excel Discussion (Misc queries) | |||
snapshot viewer print protection error | Excel Discussion (Misc queries) |