Gurus,
I have to code below that brings up the "Save As" box to save a file which is in AP3.
It works well, except, if the user selects cancel, instead of save, the file is saved as False. What I am looking for is the code that exits the macro (and doesn't save the file) when Cancel is selected. Any ideas?
TIA,
Tim
Please Login or Register to view this content.
Last edited by TimlmiT; 05-16-2014 at 12:36 PM.
Hi, TimlmiT,
maybe try it like this:
Please Login or Register to view this content.
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
HaHoBe,
Works great! I am not sure if I understand why or what makes the difference between it being a strPath and varPath, nevertheless it works.
Thank you!
TimlmiT (novice)
Hi, Tim,
strPath was dimensioned as String which may only take a string (not so surprising). If the user cancelled a Boolean is raised which canīt be covered by a String. A Variant can take any type (as well String as Boolean) so declaring the variable as Variant will work.
HTH,
Holger
Thank you for your explanation.
Holger,
Can you help me with this one? The code is slightly different when saving it as an .xlsm file. I get the same "false.xlsm" file if the user selects cancel.
TIA,Please Login or Register to view this content.
Tim
Hi, Tim,
I donīt think you would need to use a variable for the suggested name but could use the range directly.Please Login or Register to view this content.
Ciao,
Holger
Holger,
Thank you for the help.
However, in the picture, you can see that the file name (Green) and value (Blue) are the same. But when SAVE is selected on the menu, the result (Red) has and additional "." on the end of the file name.
excel.jpg
Any clues of why this is happening?
Thanks,
Tim
Hi, Tim,
my last code is for *.xlsm so you would need to review the code to ExportAsFixedFormat and see if you would need to either cut off one more character from the filename or add only pdf without a dot. I canīt find any reason ad hoc - sorry.
Ciao,
Holger
Holger,
Below is the code for both the Save_As and Save_PDF. I played around with the Save_PDF and found that in order for it not to add the period to the end of the file name, I had make the filename = to a string and not a variable. Not sure why, but it works great now.
Thanks for your help.
Tim
Please 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