mcs26
asked on
VBA GetSaveAsFilename
Hi,
I am using the GetSaveAsFilename method to allow a user to select where they wish to save a file. The only problem is that I cannot seem to specify where the default save location should be? Or do I have to use another method?
Any thanks would be great,
Mark
I am using the GetSaveAsFilename method to allow a user to select where they wish to save a file. The only problem is that I cannot seem to specify where the default save location should be? Or do I have to use another method?
Any thanks would be great,
Mark
ASKER
isn't the first argument of the GetSaveAsFilename method "intial filename"?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the way I suggested makes you feel uncomfortable, or there's another reason you can't use it, you can also do this:
ChDir("C:\SomeDir")
Application.GetSaveAsFileN ame
ChDir("C:\SomeDir")
Application.GetSaveAsFileN
ASKER
ah I should never have doubted you!
Application.GetSaveAsFileN