Using a macro, how can i convert one excel sheet to one pdf file using loops etc.
e.g. Go to sheet named "sheet1"
save this sheet as "sheet1.pdf"..
Go to "sheet2"
save this sheet as "sheet2.pdf"
etc
Using a macro, how can i convert one excel sheet to one pdf file using loops etc.
e.g. Go to sheet named "sheet1"
save this sheet as "sheet1.pdf"..
Go to "sheet2"
save this sheet as "sheet2.pdf"
etc
Last edited by pr4t3ek; 08-14-2009 at 02:54 AM.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
It depends which PDF writer that you ar using.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Found a solution here:
http://www.vbforums.com/showthread.php?t=542212
Thanks
That works with PDFCreator, thanks for sharing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks