Run-Time Error 1004 Unable to sett the RightHeader property of the PageSetupClass

[ThrottleWorks]

Hi,

I am running a macro for setting Header of the files.
I have not prepapred this macro, the person who has developed this has left the firm.

When trying to run the macro I get the following bug.
"Run-Time Error 1004 Unable to sett the RightHeader property of the PageSetupClass".

Can anyone please tell me what will be cause.

 

[Hui]

Header.xls is a 97-2003 Excel file

It works fine in Excel 2010

What version are you using ?

I think you should also save the file as a Macro file eg: *.xlm not *.xls

 

[ThrottleWorks]

I am using Excel 2010 only, I forgot to mention, I am the only person who is getting this error.
The macro is running fine on other PCs, should have mentioned earlier.

Version is 14, the entire value is 14.0.6112.5000 (32-bit)

P.S. - Sir facing same problem with XLM file also.

 

[Hui]

Here is a wild stab

Try changeing the two lines
wb.ActiveSheet.PageSetup.RightHeader = Sclassification
wb.ActiveSheet.PageSetup.LeftHeader = ""

to:
ActiveSheet.PageSetup.RightHeader = Sclassification
ActiveSheet.PageSetup.LeftHeader = ""

 

[ThrottleWorks]

Thanks a lot Sir ! I think I have got it, I am not able to verify it, the macro is still running.

The isssue I think was, there was no pritner connected to excel.
I have changed the printer settings & it seems to work now, will verify in few minutes.

I got clue from following link.

http://www.teachexcel.com/excel-help/excel-how-to.php?i=219100

Have a nice day ahead.

P.S. - Sir do not know the logic, but it is working now.