ChrisJRutter
Member
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:ActiveSheetageSetup:LeftHeader = "This is the left side".
chExcel:ActiveSheetageSetup:CenterHeader = "This is center".
Or is there a way to combine both properties into one statement?
I have tried the following without success:
chExcel:ActiveSheetageSetup:LeftHeader = 'This is the left side",:CenterHeader = 'This is center'.
Thanks in advance.
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:ActiveSheetageSetup:LeftHeader = "This is the left side".
chExcel:ActiveSheetageSetup:CenterHeader = "This is center".
Or is there a way to combine both properties into one statement?
I have tried the following without success:
chExcel:ActiveSheetageSetup:LeftHeader = 'This is the left side",:CenterHeader = 'This is center'.
Thanks in advance.