Excel not reading default printer settings afte the file is saved??
Sainath
We are developing a Excel solution for our customer using
VB macros(to cutomize printing).
Observation when running excel without our macro:
Open a new worksheet. Make changes to the sheet. Save the
file and exit.
Now click on "start" menu button & open the default
printer settings from the "control panel".
Modify the default settings. For example, change the
printing mode to "Landscape" from "Portrait".
Now launch excel again, open the file you had saved
previously and check the printer settings.
Even though you changed the default printer settings of
the entire system, Excel does not
allow the user to see the modified default printer
settings, once the file is saved.
The only way to change the excel file settings is to open
the files, individually, and
apply the new print settings from within excel. This is
the behavior that we have observed.
I went a step further to investigate what was happening.
Internally within each .xls file,
excel stores the DEVMODE settings. So even though we may
change the printer settings from the control
Panel, the .xls file does not get the change.
My question to Excel gurus is:
Is there a way to apply the "control panel" printer
settings changes to "saved" Excel files,
automatically or programmatically?
Thanks,
-Sainath