Print specific worksheets from several different workbooks

[twarden]

Hopefully this will be simple. I am looking for a macro that I can use to print specific worksheets in various workbooks from one location. For instance:

Let's say I have 10 different reports (workbooks) each with 4 or 5 worksheets - and I want to print the following:

Workbook 1: SheetA, SheetB
Workbook 2: SheetE, SheetA
Workbook 3: SheetC
Workbook 4: SheetA, SheetB, SheetD

etc, etc, etc.

Is there a way to do this all at once?

 

[Datsmart]

This previous thread may help you.
http://www.mrexcel.com/board2/viewtopic.php?p=1181105

 

[twarden]

Hi John - I gave a look at the post you referred to - but I think that's a bit beyond the level I'm at in terms of macros - I really am a very basic beginner. Any other suggestions?

 

[Datsmart]

Copy the suggested code into a VBA Module.
Setup a Table similar to the one below with your Path, Filenames, and worksheets you want printed.

Excel Workbook
	A	B	C
1	Path	Filename	Sheet
2	C:\~~~\Test\newTest\	TestOne.xls	Sheet1
3	C:\~~~\Test\newTest\	TestTwo.xls	Sheet2
4	C:\~~~\Test\newTest\	TestThree.xls	Johnson1
Sheet

Run the "OpenPrint" macro to print out the pages.