I am currently using the code below to convert a cell range to a PDF file and automatically save it to a spot on a network drive with a predetermined name. How can I add a condition to this so that it only actually saves the PDF to that folder when the following conditions are met:
E8 OR E10 OR E11 OR E13 = TRUE AND E17 OR E18 OR E19 OR E20 = TRUE
Please Login or Register to view this content.
Last edited by jonvanwyk; 07-19-2011 at 10:55 AM.
Something like:
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!)
Please Login or Register to view this content.
Hey guys...thank you very much...your suggestions worked flawlessly. However, depending on the cells and true statements, sometimes I need the PDF to go to an email as an attachment instead of being saved to a network drive. How can I modify the above code to send the PDF to a specific email address when those conditions are met?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks