Retrieve Center Header String

[Ken Hudson]

As part of a macro I am opening an existing workbook. That WB has a center
header in the print set up. How can I pull that center header string into the
macro and assign it to a variable?

Dim SHeader as String
Sub GetHeader
Workbooks.Open "Test.xls"
sHeader= what?
...........
........
End Sub

 

[Rick Rothstein]

Assign the PageSetup.CenterHeader property for the worksheet to your
variable.

 

[Ken Hudson]

I can't get the code right to do this.

sHeader=PageSetup.CenterHeader

doesn't work?

 

[Ken Hudson]

orry Rick, I got it. I needed:

sHeader=ActiveSheet.PageSeetup.CenterHeader

My apologies.