I've searched but haven't found the answer I need.
I use a macro to read a list of names, fill in a template and produce a sheet per name (timesheets). So 25 names give me 25 timesheets. Initially I printed each sheet but now I want to create a single pdf file with the 25 sheets in it. All I've been able to come up with so far is 25 pdf's.
Any ideas?
Thanks for the help...ptm
This is one of those rare moments you have to actually "select" something in VBA to get it to do what you want. This code would select the three sheets noted and then print them as a single print job.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
JB, since I will have 25 timesheets, do I need the "Sheets(Array" to list out Sheet1 .... Sheet25? I guess as I build each sheet I will have to increment the Sheet #?Originally Posted by JBeaucaire
This is one of those rare moments you have to actually "select" something in VBA to get it to do what you want. This code would select the three sheets noted and then print them as a single print job.
Please Login or Register to view this content.
Thanks...ptm
Maybe there's a better way.
1) are there other sheets in the workbook that WON'T be part of the print job, or is this a "print all sheets in the workbook as a single print job?"
2) If there are others to exclude, what are those sheet names?
There is a second sheet named "Names" where I keep the list of teachers for whom I am creating timesheets.
ptm
The way I showed you above would give you the most control.
If you want to try and create a macro that can dynamically decide which sheets to collect and print all together, that can be done, but is it worth the effort? You have the control you need already.
To make it dynamic, you'd need to:
1) Use a trick for deciding which sheets to include based on the sheet names themselves, something they all have in common, like Sheet1, Sheet2, Sheet3, etc.
...or
2) Make a permanent list of the few sheet names that are always NOT print and then collect all the other sheet names dynamically except those.
Is there anyway to modify this code to get it to save the selected sheets into a new workbook ?This is one of those rare moments you have to actually "select" something in VBA to get it to do what you want. This code would select the three sheets noted and then print them as a single print job.
Please Login or Register to view this content.
I am writing a macro that extracts sheets from a workbook and emails them, except I can only get the macro to email indivdual sheets from the workbook, but I want it to save the extracted sheets into one workbook and then email the workbook.
This line of code will copy the sheets in the array into a new unsaved workbook.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks