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