hi all,
I have the code below that saves the worksheet as a pdf. it saves it to My Documents as default, how do I change it to save to a specific destination?
thanks in advancePlease Login or Register to view this content.
hi all,
I have the code below that saves the worksheet as a pdf. it saves it to My Documents as default, how do I change it to save to a specific destination?
thanks in advancePlease Login or Register to view this content.
what is the value inPlease Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
hi Naveed,
the WS I'm saving is a Purchase Order, the value in ("E7") is the Purchase Order Number which I generate manually.
Nick
Hi Nich
replace your code with below one
Please Login or Register to view this content.
hi Naveed,
not sure how I write the file path within the quotes. I'm trying to save it to my "Z drive", so is it "=z:\Folder\"
Nick
Please Login or Register to view this content.
Thanks Naveed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks