Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,173
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Headers & Footers bob Excel Discussion (Misc queries) 2 May 8th 12 07:32 PM
Importing Excel report into Word showing headers and footers LossManiac Excel Discussion (Misc queries) 1 August 29th 08 01:56 PM
Using Graphics in Excel sheet Headers & Footers Aaron West Excel Discussion (Misc queries) 4 September 6th 06 09:26 PM
Can I edit headers/footers for an entire workbook? On Line All The Time Excel Discussion (Misc queries) 2 December 1st 05 12:23 AM
How can I set up headers/footers for an entire workbook vs sheet jaydub Excel Discussion (Misc queries) 1 September 21st 05 05:57 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"