Easy Excel question

Hi All

This should be an easy question...

If I want to send the follow commands to Excel:

With ActiveSheet.PageSetup
.LeftHeader = "This is the left side"
.CenterHeader = "This is center"

Would I need to send as:

chExcel:ActiveSheet:pageSetup:LeftHeader = "This is the left side".
chExcel:ActiveSheet:pageSetup:CenterHeader = "This is center".

Or is there a way to combine both properties into one statement?

I have tried the following without success:

chExcel:ActiveSheet:pageSetup:LeftHeader = 'This is the left side",:CenterHeader = 'This is center'.

Thanks in advance.
 
Top