печать определенных листов из множества книг

Printing Selected Worksheets
авторSummary: Need to print just a few worksheets out of a group of workbooks? There’s no need to manually load each workbook and print the sheets; instead you can use the macro presented in this tip. It allows you to print selected worksheets from each workbook in a particular folder. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

авторIf you have a lot of workbooks that have accumulated over the years, you may have a need to print some of the worksheets out of each of them. For instance, you may need to print the second and third worksheets out of each workbook in a folder. Loading each workbook and then printing selected sheets could take a huge amount of time.

A quicker way is to create a macro that will do the printing for you. The following macro starts by asking you for a directory path. Provided that you specify a path, the macro then starts to load each XLS (Excel) file in the directory, and then print the second and third worksheet from each one. Once printed, the worksheet is closed.

авторObviously, if you have quite a few workbooks in the directory, printing could take quite some time. You may want to find some time when you have nothing else to do, and then just let the macro start running.

статья на вынос (см. внизу)

савэт с - http://exceltips.vitalnews.com/Pages/T0295_Printing_Selected_Worksheets.html