Export Entire Excel Sheet with headers, footers, etc, to Word
 

I have an Excel macro that creates a sheet in Excel exactly as I want
it to appear. I need to export it to Word (client wishes). I have
been able to export the sheet contents to Word automatically, but not
the headers and footers like they appear in the Print Preview. Does
anyone know how to do this?

Stacey

Export Entire Excel Sheet with headers, footers, etc, to Word
 

Stacey

This is a collaboration between Excel and the print drivers, therefore you
cannot do this easily. I suspect the only way you may be able to is to
created a PDF or similar and get that into word (?????)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Stacey Hartley" wrote in message
om...
I have an Excel macro that creates a sheet in Excel exactly as I want
it to appear. I need to export it to Word (client wishes). I have
been able to export the sheet contents to Word automatically, but not
the headers and footers like they appear in the Print Preview. Does
anyone know how to do this?

Stacey