Hi all,
I am getting the header and footer information using
Code:
With ActiveSheet.PageSetup
strleftheader = .LeftHeader
strCenterHeader = .CenterHeader
strRightHeader = .RightHeader
strLeftFooter = .LeftFooter
strCenterFooter = .CenterFooter
strRightFooter = .RightFooter
End With
What I need is the entire header and footer content to be pasted in word document.
An Example:
If I am getting strleftheader as &"Tahoma,Bold"&12xyaaaa
&P&N&D&T&Z&F&F&A&G
whether I need to decode it and then paste it in word.
Do anyother ways exist to copy the excel header and footer content to word.
Thanks in advance,
Thoppae