"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.