Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Word & Excel - Nice question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HS - 28 Jan 2008 23:51 GMT
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
Harlan Grove - 29 Jan 2008 01:13 GMT
"HS" <hem...@hemang.net> wrote...
>Scenario:
>
[quoted text clipped - 10 lines]
>
>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.
Tony Jollans - 29 Jan 2008 02:02 GMT
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.

Signature

Enjoy,
Tony

> Scenario:
>
[quoted text clipped - 29 lines]
>
> Thank You
HS - 29 Jan 2008 19:47 GMT
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

>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.
[quoted text clipped - 32 lines]
>>
>> Thank You
Micheal LoPatriello - 03 Mar 2008 19:25 GMT
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.
Signature

Micheal LoPatriello
Coordinator,
Luna Development
mlopat@lunadevelopment.com
http://www.lunadevelopment.com

> Thanks Harlan & Tony
>
[quoted text clipped - 42 lines]
> >>
> >> Thank You

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.