Runtime error prevents Excel 2000 to save file

G

GC

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?!
 
G

GC

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error when trying to save Excel 2000 worksheet from VB app 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Macro Runtime errors 8
Runtime error R6034 0
Runtime Error 1004 1
excel found unreadable content' error is coming while opening xlsx file 0
'excel found unreadable content' error is coming while opening xlsx file 0
Excel 2003 Runtime error 40036 6

Top