Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.word.docmanagement
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel, microsoft.public.excel.worksheet.functions,microsoft.public.word.docmanagement
|
|||
|
|||
Word & Excel - Nice question
"HS" wrote...
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). .... 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. So they're printing the Excel worksheets using automatic image compression to ensure that each worksheet prints on just one page? You're close. How about inserting 40 blank worksheets between the 40 original worksheets so they alternate between blank and original worksheets, then copying each page from Word and pasting them AS PICTURES into the blank worksheets. I'd figure there'd be a lot less trouble printing the Word pages as images pasted into the Excel workbook. It should be possible to automate this using VBA. Alternatively, tell 'em to buy Adobe Acrobat (the full product, NOT Reader) if they don't have a legal copy, then us it to insert the pages from either the Word or Excel PDF file into alternating pages in the other PDF file. This would be a manual process. |
#3
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.word.docmanagement
|
|||
|
|||
Word & Excel - Nice question
I think you can do this direct, page by page, with VBA to a single PDF using
PDFCreator - see http://www.excelguru.ca/node/21 for more details. -- Enjoy, Tony "HS" wrote in message ... 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 |
#4
Posted to microsoft.public.excel,microsoft.public.excel.worksheet.functions,microsoft.public.word.docmanagement
|
|||
|
|||
Word & Excel - Nice question
Thanks Harlan & Tony
Tony, this would let Excel print to pdf, how do I get my pages from word in there? Is there any sample code for that? Thanks "Tony Jollans" <My forename at my surname dot com wrote in message ... I think you can do this direct, page by page, with VBA to a single PDF using PDFCreator - see http://www.excelguru.ca/node/21 for more details. -- Enjoy, Tony "HS" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.word.docmanagement,microsoft.public.excel
|
|||
|
|||
Word & Excel - Nice question
Another option would be to print both docs to pdf and then use Adobe Acrobat
Professional to just arrange the pages as you like in whatever order they want and save back to PDF. -- Micheal LoPatriello Coordinator, Luna Development http://www.lunadevelopment.com "HS" wrote: Thanks Harlan & Tony Tony, this would let Excel print to pdf, how do I get my pages from word in there? Is there any sample code for that? Thanks "Tony Jollans" <My forename at my surname dot com wrote in message ... I think you can do this direct, page by page, with VBA to a single PDF using PDFCreator - see http://www.excelguru.ca/node/21 for more details. -- Enjoy, Tony "HS" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I very nice reports from excel Please ? | Excel Worksheet Functions | |||
Printing out nice reports in Excel | Excel Discussion (Misc queries) | |||
Question about Word export to excel? | Excel Worksheet Functions | |||
Question - Excel Comments to Word Footnotes | Excel Discussion (Misc queries) | |||
Final House Walkthrough inspection in Excel would be nice | Setting up and Configuration of Excel |