LinkBack URL
About LinkBacks
Hi All,
Does anyone have a macro built already that will allow a user to select a folder and print all workbooks in this folder?
To add a variable, some of these workbooks will have more than 1 sheet.
Thanks!
Dvent
Hi All,
Does anyone have a macro built already that will allow a user to select a folder and print all workbooks in this folder?
To add a variable, some of these workbooks will have more than 1 sheet.
Thanks!
Dvent
Hi,
Take a look at this:
http://exceltip.com/st/Print_all_wor...Excel/455.html
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
hi sweep
when i paste this into a module I dont appear to be able to run it. can you spot any character errors that would stop this?
dvent
What do you mean by "I dont appear to be able to run it."?
You may need to replace this line
with this
Please Login or Register to view this content.
As you're using XL2007.Please Login or Register to view this content.
Last edited by sweep; 02-17-2009 at 06:38 AM.
The workbooks I will be printing will be .xls
The problem is I have pasted this into VB. Press the Green play button, and it asks me which macro to run. The PrintAllWorkbooksInFolder macro is not listed here.
OK,
If you take a look at the first couple of lines of the code there are examples of the usage.
Once you've pasted the code, you'll have to call it from another procedure, eg
Then run CallPrintRoutine from excel.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks