Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Runtime error prevents Excel 2000 to save file
I have a VB 6.0 application that creates reports using Excel 2000. The
application has been working fine but recently I installed it on a new hard drive (same configuration) and now I get a run time error everytime I try to save the excel report. The error is: Runtime error '1004'. "Unable to set the CenterHeader Property of the Page Setup class." Can anyone help me troubleshoot this problem?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Runtime error prevents Excel 2000 to save file
Try resetting the default printer to a real printer?
Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "GC" wrote in message ... I have a VB 6.0 application that creates reports using Excel 2000. The application has been working fine but recently I installed it on a new hard drive (same configuration) and now I get a run time error everytime I try to save the excel report. The error is: Runtime error '1004'. "Unable to set the CenterHeader Property of the Page Setup class." Can anyone help me troubleshoot this problem?! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Runtime error prevents Excel 2000 to save file
Thanks a million Charles. This worked like a charm. I don't have a printer
on my system but I setup a fake one and the error went away. I didn't know excel properties were directly related to the printer. I learn something new. I guess I have to put additional checks in my application in case a printer is not present. Thanks again for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save excel file before printing | Excel Worksheet Functions | |||
Excel kept on asking to save file every time I jump from one sheet to another! | Excel Worksheet Functions | |||
Save in Multiple format crashes Excel 2000 SP3! | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel |