software

Hello,

Usually, directly in a folder in windows I select all my excel files, right
click and select quot;printquot;. 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

No.

You will have to move or copy the other sheets to individual wotkbooks.quot;krikriquot; wrote:

gt; Hello,
gt;
gt; Usually, directly in a folder in windows I select all my excel files, right
gt; click and select quot;printquot;. Then, all my files print out. The thing is that it
gt; prints just the first sheet, and some files have more that one sheet. Is
gt; there a way to print all of the sheets of all of the selected files without
gt; opening every Excel files, because I have lots of them..
gt;
gt; Thanks

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!
quot;exceluserforemanquot; wrote:

gt; No.
gt;
gt; You will have to move or copy the other sheets to individual wotkbooks.
gt;
gt;
gt; quot;krikriquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; Usually, directly in a folder in windows I select all my excel files, right
gt; gt; click and select quot;printquot;. Then, all my files print out. The thing is that it
gt; gt; prints just the first sheet, and some files have more that one sheet. Is
gt; gt; there a way to print all of the sheets of all of the selected files without
gt; gt; opening every Excel files, because I have lots of them..
gt; gt;
gt; gt; Thanks