you can use like this. string fileFilter = “Excel Workbook (*.xlsx),*.xlsx,” + “Excel Macro-Enabled Workbook (*.xlsm),*.xlsm,” + //”Excel Binary. Try this. Code: Sub Xxxxx_SaveAs() Dim fname fname = Application. GetSaveAsFilename(InitialFileName:=””, FileFilter:=”Excel Files (*.XLS), *. GetSaveAsFilename([InitialFilename], [FileFilter], [FilterIndex], [Title], [ButtonText]) Synopsis Displays the Save File As dialog box and returns a filename or False.

Author: Kazisar Nijas
Country: South Sudan
Language: English (Spanish)
Genre: Technology
Published (Last): 17 December 2009
Pages: 380
PDF File Size: 14.37 Mb
ePub File Size: 20.34 Mb
ISBN: 909-8-23964-839-1
Downloads: 91283
Price: Free* [*Free Regsitration Required]
Uploader: Nakus

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. Pretty helpful and totally understanable for the dummies like me. So im asuming that i need to have some code that runs after the user clicks save, that checks if the file already exists, and then, if it does, brings up a msgbox to ask if they want to overright.

Can you point me to the bit you were trying to show me? Apply filters to the save file dialog. Please Sign up or sign in to vote. If the user chooses a file name, the example displays that file name in a message box.


Your email address will not be published. Note the save file dialog will not actually save the file. Great Post, thanks for sharing.

Results 1 to 6 of 6. Let’s work to help developers, not make them feel stupid.

GetSaveAsFilename File Filter problem

Top Rated Most Recent. Title Optional Variant Specifies the title of the dialog box. Chances are they have and don’t get it. However, you got to the save location and there is nothing. How would that look please.

Use code tags around code. Your help has been much appreciated and has solved my issue. A path with no file extension.

There are several different methods for creating a save file dialog. Insults are not welcome. What are you doing?

Login or Sign Up. It only returns the full path the user has selected to save the file. How to add Excel like filter in DataGridView.

Further, is there a way to default the Save as t ype to. Thank you very much. Treat my content as plain text, not as HTML. If this argument is omitted, Microsoft Excel uses the active workbook’s name. Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.


Application.GetSaveAsFilename method (Excel)

The time now is If this is your first visit, be sure to check out the Board FAQ by clicking the link above. Once again, great job. Results 1 to 7 of 7.

Thank you – I will do. The example below creates 2 filters a. There are no open issues.

Add filters in GetSaveAsFileName

Nobody knows the trouble I’ve not seen! Specifies the suggested file name. GetSaveAsFilename November 2nd, Trying to set filename to cell A1 Value, but this does not work.