The following is part of code that I'm using to turn an Excel worksheet into a PDF and then email it. Right now, it saves the PDF to my desktop. I can get it to save it to my C drive by simply replacing "Desktop" with "C:". However, I am unable to get it to save to a network drive such as "I:\Archive". When I use the I drive as a path, the rest of the macro works fine but the PDF doesn't save anywhere.
Any idea what I'm doing wrong?
Thanks,
Steve
Please Login or Register to view this content.
pdffile just needs to be a string I believe... untested but try:
tested now, should work fine.Please Login or Register to view this content.
Last edited by Arkadi; 03-18-2015 at 11:25 AM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
When you say replace Desktop with filepath, you do mean replace the whole preceding line, correct?
This went to my network share just fine.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thanks - that did the trick. I appreciate your help!Originally Posted by Arkadi
pdffile just needs to be a string I believe... untested but try:
tested now, should work fine.Please Login or Register to view this content.
Great Steve! Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks