Oh the joys of manipulating data. I work in the NHS and for retail organisations, helping to make sense of the raw data that they generate. The tools available are varied and almost always wrong the wrong ones :) This blog is my incidental musings of things that have frustrated or interested me and I hope they will help to overcome some of the pitfalls I have encountered or inspire you to find new ways to solve your problems.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment