Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch printing without VBA
Hello,
Usually, directly in a folder in windows I select all my excel files, right click and select "print". Then, all my files print out. The thing is that it prints just the first sheet, and some files have more that one sheet. Is there a way to print all of the sheets of all of the selected files without opening every Excel files, because I have lots of them.. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch printing without VBA
No.
You will have to move or copy the other sheets to individual wotkbooks. "krikri" wrote: Hello, Usually, directly in a folder in windows I select all my excel files, right click and select "print". Then, all my files print out. The thing is that it prints just the first sheet, and some files have more that one sheet. Is there a way to print all of the sheets of all of the selected files without opening every Excel files, because I have lots of them.. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch printing without VBA
So then it's worst then before because I have to open every workbook and save
each sheet in another workbook, even if some sheets have relation between them... Ok finally I guess I prefer a VBA solution! "exceluserforeman" wrote: No. You will have to move or copy the other sheets to individual wotkbooks. "krikri" wrote: Hello, Usually, directly in a folder in windows I select all my excel files, right click and select "print". Then, all my files print out. The thing is that it prints just the first sheet, and some files have more that one sheet. Is there a way to print all of the sheets of all of the selected files without opening every Excel files, because I have lots of them.. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing changes from 2000 to 2003 | Excel Discussion (Misc queries) | |||
Printing in Excel overlaps previous text | Excel Discussion (Misc queries) | |||
Printing is slow: Any suggestions | Excel Discussion (Misc queries) | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
problem printing to PDF | Excel Discussion (Misc queries) |