There may be times when you need to ask the user to select a location to save a file. This can be done using a save file dialog. Keep in mind. Morning All, I have a macro that modifies a standard template. At the end of this macro I want a save as dialogue that opens up in a default. Trying to set filename to cell A1 Value, but this does not work. what am I doing wrong please. TY Sub Move_Copy_Save() Dim varResult As.

Author: Nelrajas Goltikora
Country: Malta
Language: English (Spanish)
Genre: Music
Published (Last): 9 March 2018
Pages: 345
PDF File Size: 17.52 Mb
ePub File Size: 18.29 Mb
ISBN: 547-2-95365-195-4
Downloads: 11321
Price: Free* [*Free Regsitration Required]
Uploader: Natilar

There were no file filters to choose from:. The returned name may include a path specification.

eAsFilename Help – Free Excel\VBA Help Forum

Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

To do that and getting the new name of the file I’m using the Application. Results 1 to 7 of 7. If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me.

The only time vSavename is a Boolean is when the user cancels, so this approach doesn’t need to know how to say False in the user’s language.

I have a module and have added the Excel 9. Results 1 to 6 of 6. I get a debug error on the last line of this code: It opens up the save as Dialogue and I can pick a file name getsaveasfilrname destination and that getsaeasfilename copied to DestFile just like I want.


GetSaveAsFilename question Morning all I was just wondering how i go about making the GetSaveAsFilename method to ask if you want to overwrite a file that already exists becuase all it does is return a string containing a filename. The majority of my users will currently be usingbut we are ungoing a move to Return value Variant Remarks This string passed in the FileFilter argument consists of pairs of file filter strings followed by the MS-DOS wildcard file filter specification, with each part and each pair separated by commas.

HTH, Peter Please test any code on a copy of your workbook. Note the save file dialog will not actually save the file. Can you point me to the bit you were trying to show me? Hit the S ave button and you think all is done.

Thank you very much.

Member List Calendar Forum Rules. Xecel a Reply Cancel reply Your email address will not be published. Sign in to give feedback. Our new feedback system is built on GitHub Issues. A path with no file extension.

Pretty helpful and totally understanable for the dummies like me.

Application.GetSaveAsFilename method (Excel)

Can it be used in an Access module? If they click no, then it brings the ‘save as’ gdtsaveasfilename back up. Thank you again and all the best. Your help has been much appreciated and has solved my issue. FileFilter Optional Variant A string specifying file filtering criteria.

I agreed to these rules. As Vityata mentioned I am in Germany and thus could have run getsaveasfileanme problems with the language, fortunately for me Vityata reminded me gtsaveasfilename the problem because I am in fact using Excel in English, but not all of my colleagues are, so my accepted answer might not have worked when they were using the workbook.


Afternoon, I’m currently using the following basic code, but for some reason it doesnt actually save to any location. However, you got to the save location and there is nothing. To use multiple MS-DOS wildcard expressions for a single file filter type, separate the wildcard expressions with semicolons; for example, “Visual Basic Files. Any help would be appreciated!

You can tell the dialog to start in a specific folder. This one displays the standard Save dialog box. The code below opens a save file dialog with the. And on Windows, it does not work the way the help claims.

All contents Copyright by MrExcel Publishing. The code below runs fine, BUT, it isn’t actually saving the file. Leave this field empty. May 19th, Thanks for the help. Sign up using Email and Password. However, it turns out that if the filterindex setting does not exactly match the filetype as the workbook currently has, then the ActiveWorkbook.

Edit This piece of xld ‘s code is getsaveafilename I’ve got this to work now, but I get the dialogue box asking if I’m sure I want to save as a macro free workbook.

Returns False if the user cancels the dialog box. There was a problem with Example 1.