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: Akiran Malarn
Country: Tunisia
Language: English (Spanish)
Genre: Literature
Published (Last): 4 September 2007
Pages: 347
PDF File Size: 20.4 Mb
ePub File Size: 14.66 Mb
ISBN: 453-7-97394-257-9
Downloads: 39423
Price: Free* [*Free Regsitration Required]
Uploader: Kelar

Close ; I have used this code. All contents Copyright by MrExcel Publishing. Resources saved on this page: Our new feedback system is built on GitHub Issues. Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. Thanks for the help.

You can download the file and code related to this article here. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted. Chances are they have and don’t get it.


eAsFilename method (Excel) | Microsoft Docs

Read about this change in our blog post. Let’s work to help developers, not make them feel stupid. The example below creates 2 filters a. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem.

Ask the user to input the file extension every time he decides to save a file:. As fklefilter can see this time the. Become a Registered Member free to remove the ads that appear in thread area.

XLSM if you want to save getsaveasfiilename an Excel file format. Edit This piece of xld ‘s code is better: I have added them for you today. In order for this not to happen you have 2 options:. How would that look please.

Don’t tell someone to read the manual. You can tell the dialog to start in a specific folder.

I’ve populated the “” getsafeasfilename the desired filename prefix and this now works great. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy. Example This example displays the Save As dialog box, with the file filter set to text files.

Hi, Please help me how to set filters in Asp. Leave a Reply Cancel reply Your email address will not be published. Last edited by k13r4n; at Share it with others Like this thread?

TOP Related Posts  ASTM D5882 PDF

November 2nd, Once again, great job. How to add filters to headers in CSV File. To use multiple MS-DOS wildcard expressions for a single file filter type, separate the wildcard expressions with semicolons; for example, “Visual Basic Files.


The path selected is printed in cell A Highlight your code and click the icon at the top of your post window. The actions all complete as expected, except for actually saving it. If this argument is omitted, Microsoft Excel uses the active workbook’s name. Can you please elaborate on what exactly you want to achieve???

How to add filter in datagidview. How to add filter in gridview? Selecting NO raises Run-time error ”: Pretty helpful and totally understanable for the dummies like me.

FilterIndex Optional Variant Specifies the index number of the default file filtering criteria, from 1 to the number of filters specified in FileFilter.