LinkBack URL
About LinkBacks
Hi All
Any idea how to vba a macro which:
For all workbooks in a folder will print all worksheets as individual pdf's while using(naming) the pdf by the sheetname.
Best regards
Emil
Printing multiple workbooks with multiple worksheets into pdf
Hi All
Any idea how to vba a macro which:
For all workbooks in a folder will print all worksheets as individual pdf's while using(naming) the pdf by the sheetname.
Best regards
Emil
Something like this:
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!)
First a BIG big big thank you for helping out, the structure is a big big help.
Secondly I really would like to understand til ExportAsFixedFormat function so I have attempted to combine some of my existing code, with the ideas you provided.
However Im stuck in a error 438.I know it only works(or was supposed to) in my active wb, before moving on to the working on different wbs.
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