ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Runtime error when trying to save Excel 2000 worksheet from VB app (https://www.excelbanter.com/excel-programming/381901-runtime-error-when-trying-save-excel-2000-worksheet-vbulletin-app.html)

gc

Runtime error when trying to save Excel 2000 worksheet from VB app
 
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 every time 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?!

Jim Rech

Runtime error when trying to save Excel 2000 worksheet from VB app
 
Have you installed a printer driver?

--
Jim
"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 every time 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?!




All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com