Program error in XP

I have a program that I wrote in VB6 with an access database and reports that are run to excel. The reports to excel work fine from most computers, but from others it gives an Error 1004....Unable to set the PrintTitleRows property of the PageSetup class, or Error 1004....Unalbe to set the RightFooter property of the PageSetup class. Our network administrator seems to think it is an issue with certain people not having administrator rights, but when I install and try to run the program while logged in a administrator, I get the same error.

Any help is appreciated. Thanks!
Chrissy

Is a printer set up on those PC's? (if not, you will get those errors)

Is it the same version of Office? The same documents?

What is the code for that part of the program? (just a few lines will probably be enough to see any issues).

The printer was the problem. Thank you so much!!