I got more than 200 excel files that I need printed, would be lovely if anyone would be able to help me find a easy way to to that
Cheers
Print a lot of Workbooks
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
Hi GZ
Go into Windows Explorer, select all the Workbooks. Then right click and choose Print.
-
Hi
Thanks for the suggestion but it doesn't work
-
Any hints as to what happens when you try????
It works for Windows XP. Try the same from within Excel (File>Open) it works from there as well.
-
-
Quote
one file gets printed
Do you mean only 1 worksheet gets printed or only 1 workbook?
BTW I'm on XL97, NT and it works.
-
Quote from norie
Do you mean only 1 worksheet gets printed or only 1 workbook?
BTW I'm on XL97, NT and it works.
Every workbook only got one worksheet
It does ? Hmm maybe it is the end user that is the problem then - me that is
What I did was browse to the folder where the files are located then mark the ones I want to print and click print.I found another way to do it, I made a shortcut to the printer put it in the send to folder. Marked the ones to print and then send to and picked printer. Now for the first time I got a message saying I am trying to print more than one and ask if that is what I want to do. When I agree to it, it does the job, but I have to agree to allow every file to use macros and and answer if I want to save changes (even though no changes was made)
-
Well, Windows should be the best way to do all that printing.
There is another thread about opening several workbooks and copying data into one workbook. You could change that code to print each file instead of copying the data.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!