Hi all
Just a quick one (hopefully). Having trouble with establishing an overwrite protocol when saving something as PDf.
The current code I am utilising is below, however it does not prompt to overwrite, instead not saving at all (I presume due to the error in the 4th line)
Code is as follows:
Thank you in advance!
Please Login or Register to view this content.
Hi, in the first place I would check if the file already exists, because as you said, no warning is given,
secondly I would rewrite this, as this gives an error (you ruled that out in line 4):
intoPlease Login or Register to view this content.
CheersPlease Login or Register to view this content.
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Gday Erwin
Thanks for your reply mate, really do appreciate it.
Great changes, I have now updated this!
In respect to check if the file exists and overwrite it - any ideas?
Yes, you can add this into your code:
and below your macro:Please Login or Register to view this content.
CheersPlease Login or Register to view this content.
Erwin
Hi Eastwood,
Just wanted to say a huge thank you for your assistance and coding.
The code worked exactly as required; I simply changed a few things for my needs.
Really do appreciate it
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks