Thursday, 6 October 2011

Excel VBA: Application.GetSaveAsFilename

I discovered today that there is some undocumented protections built into the GetSaveAsFilename method. If you supply a filename with fullstops in it but without a valid extension then the filename that appears in the dialog box will be surrounded by quotes so make sure that you always append the correct filetype to the end of the filename if you are pulling the filename from a variable.

No comments:

Post a Comment