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

  • Thread starter Thread starter Stacey Hartley
  • Start date Start date
S

Stacey Hartley

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
 
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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word to Excel: Export comments with text and line number 0
Headers and Footers by VBA? 6
display message box in excel(2003) using VBA word(2003) 0
Exporting from excel to word: issue with data displayed in word do 1
Header & Footer from vb6 2
adding footer to all existing sheets in workbook and also to newsheets which is added 1
How to export excel sheet to CSV 1
msAccess Report Header export to Excel 3

Back
Top