I am looking for a way, either programming with VBA or buying a piece of software to be able to print different worksheets from multiple workbooks into 1 pdf.
I am trying to transform to a less paper environment. Each day I print out at least 15 - 20 different workbooks, then scan them together so that I can have 1 file for my records. Have found some tools for excel, works partially. Will print out the many sheets, but when I try to have it print out as a pdf it stops after each pdf and asks for a save as input. The one other clinker in the routine is my workbooks always contain at least 3 worksheets, the first 2 of which are not printed.
What I do today...
Open document folder for day of month
Select workbook.
Extract data I need.
Select the worksheets I need printed, always 3 - XX. Can have upwards of 10 worksheets per.
Do this for each workbook, up to 25 per day.
Scan all printed pages to a pdf.
Store pdf for future use.
Besides wasting paper, it takes time.
Would sure be nice to automate this.
Thanks in advance for your help or input......
Bookmarks