LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.word.docmanagement
HS HS is offline
external usenet poster
 
Posts: 5
Default Word & Excel - Nice question

Scenario:

Word document from page 1 to 40.

Excel File with Sheets 1 to 40 (so there are 40 sheets)

What they want is each sheet to be printed alternatively after the pages in
word.

So, the final document, to be printed, they want, Page 1(1st page of word),
page 2 (to be the 1st sheet in Excel file), page 3 (2nd page in word), page
4 (2nd sheet in excel) and so on.

They want to render this into a pdf document (print to a pdf file).

What they do now:

1) Print word document (40 pages)
2) Print Excel file (40 pages)
3) Scan each page (80 pages)
4) Arrange alternatively
5) Print to pdf.

I asked them why can't they just cut & paste the excel sheet in word, they
said, it doesn't fit in the manner the want and sometimes the table cells
spill to the second page, and they spend a lot of time tweaking and by the
time they do that for 40 sheets its way too long.

Is there a way to automate this? I'm sure there has to be a better way.

Any help would be very appreciated.

Thank You

 
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
How do I very nice reports from excel Please ? Ty Excel Worksheet Functions 3 November 2nd 07 12:19 PM
Printing out nice reports in Excel Kurt Häusler Excel Discussion (Misc queries) 3 June 14th 07 09:48 PM
Question about Word export to excel? Mr BT Excel Worksheet Functions 1 July 16th 06 06:17 PM
Question - Excel Comments to Word Footnotes Ngentot Excel Discussion (Misc queries) 0 May 18th 06 02:15 AM
Final House Walkthrough inspection in Excel would be nice Jondin Setting up and Configuration of Excel 0 February 18th 05 04:13 PM


All times are GMT +1. The time now is 07:56 AM.

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

About Us

"It's about Microsoft Excel"