Hi all
I am using this code
It is generating the file name, based on a combination of values in different cells.
Please Login or Register to view this content.
What I would like is the user to be able to acutally cancel the save process.
With the code above the file will be saved, even if the user clicks the cancel button.
Thanks for your help in advance
FD
Last edited by FallingDown; 04-11-2014 at 06:51 AM.
Hi,
you can test the return value like in the sample in the VBA help of GetSaveAsFilename method …
Regards !
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Hi patel45
I actually tried that already
The problem is that ir correctly aborts the save process.
But the actual save ends in a "Runtime Error '13' - Type Missmatch" with this code.
I can not test your code without the file
Hi Patel
Thanks - I found my mistake
For some reason i had
definedPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks