Print various excel documents to one image

User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Print various excel documents to one image

Post by VegasNath »

I am printing 18 excel documents (various worksheets / workbooks) using a macro and have set my default printer to "Microsoft Office Document Image Writer".

Is there a way to combine all of the documents into one image?
:wales: Nathan :uk:
There's no place like home.....

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Print various excel documents to one image

Post by HansV »

You can download the Microsoft Office Document Imaging Visual Basic Reference (MODI) from Microsoft (free). Perhaps that provides the info you need.
Best wishes,
Hans

User avatar
VegasNath
5StarLounger
Posts: 1185
Joined: 24 Jan 2010, 12:02
Location: Wales, UK.

Re: Print various excel documents to one image

Post by VegasNath »

Thanks Hans, I'll take a look.
:wales: Nathan :uk:
There's no place like home.....