Save file excel vba 2007

GetSaveAsFilename method precisely for these purposes. The GetSaveAsFilename method has a few parameters that allow you to customize some of its characteristics. Let's take a closer look at the method itself and its arguments, starting with:. GetSaveAsFilename doesn't save a workbook by itself. SaveAs method to actually save the Excel workbook.

You're, therefore, likely to usually use the following basic syntax for this method:. All of the 5 arguments of the GetSaveAsFilename method are optional.

Let's take a look at them:. The following table provides a basic description of the 5 parameters of the Application. I explain each of them more thoroughly below. In terms of their arguments, the main differences are as follows:. Both of these differences make sense. For example, MultiSelect allows you to determine whether a user can select multiple file names at the same time. This makes sense in the context of opening files.

But not in the context of saving files with the GetSaveAsFilename method. The InitialFilename of the Application. GetSaveAsFilename method allows you to set a suggested file name.

This suggested file name is the one that appears, by default, in the File name box of the Save As dialog. The FileFilter argument of the Application. GetSaveAsFilename method allows you to determine the criteria for file filtering within the Save As dialog box.

These file filtering criteria determine what appears in the Save as type drop-down list box of the Save As dialog box. If you omit the FileFilter argument, the default as shown in the image below is All Files. This isn't ideal because it may lead to the saved Excel workbook being of an unrecognizable file type if the user doesn't enter the file extension when saving the file.

However, my guess is that you'll be in situations where specifying the file filtering criteria is more convenient or, even, necessary.

In order to be able to determine which file filters appear in the Save As dialog box, you'll need to follow the 4 guidelines below. Don't worry if the guidelines don't seem that clear at first.

I show you a practical example of VBA code after making the introduction and basic description. Each filter you specify when using the FileFilter argument is made up of 2 strings separated by a comma. This looks, roughly, as follows:. You don't need to follow many guidelines regarding the way in which the first string String1 is specified.

However, you do need to follow a more specific syntax when specifying the second string String2. Let's take a look at it:. The second string that you use to specify a file filter is itself composed of 3 elements which are, generally speaking, as follows:. The most basic filter is all files, which in practice means that there's no filter. Other examples of file-type filter specifications following this syntax are the following:.

Knowing these first 2 guidelines is enough for you to start using the FileFilter argument. However, they only explain how to specify a single filter according to a single file type.

You can create more than a single filter with the FileFilter argument. In order to so, use commas , to separate the filters. In other words, separate each of the pair of strings that constitute a filter from the other pair of strings by using commas ,. If you need to filter according to several different data types, you can use several filters by using the syntax explained above.

Alternatively, you can specify several data types for a particular single filter. This looks roughly as follows:. Those are the 4 basic guidelines you need to bear in mind to start using the FileFilter argument. Notice that the FileFilter argument has been inserted and its syntax follows all of the guidelines I explained above. To make this clearer, let's break the argument value into its different parts and highlight how it complies with all of the guidelines described above.

The following image shows how all of the above looks like in practice. Notice how, now, there are 3 different options within the Save as Type box of the Save As dialog box. These 3 filters are those created by the FileFilter argument of the Application. This is the first filter that was specified with the FileFilter argument.

You can, however, change the default file filtering criteria by using the FilterIndex argument. You do this by specifying the index number of the criteria you want to set as default. As a consequence of the above, the FilterIndex argument can take any value between 1 the first filter and the number of filters you've specified with the FileFilter argument 3 in the example above. In other words, the practical result of specifying an index number that is too high, is the same as that of omitting the FilterIndex parameter.

The Title argument of the Application. If you omit the argument, the default title Save As is maintained. When this macro is executed, the previously called Save As dialog looks as follows. The ButtonText parameter is only applicable in the Mac platform. If you use this argument in Windows, it's simply ignored.

For those cases where it is applicable, the ButtonText argument allows you to set the text that appears in the usually known as Save button. If you've read this Excel tutorial, you now know the basics of how to save workbooks using VBA. In fact, you've seen 3 different ways to achieve this:. Additionally, in the last section of this blog post, I explained the Application.

Even though this method doesn't actually save a file by itself, it allows you to display the Save As dialog so that the users of your macro can easily specify the path and file name of the workbook they're saving. Here are some of my most popular Excel Training Resources:. If you've worked with Excel before, you're probably quite familiar with 2 basic commands for saving workbooks: Save.

Save As. The following table of contents shows the specific topics that I explain in this Excel tutorial: Table of Contents.

Inline Feedbacks. Load More Comments. Applies only if saved workbook is shared. Determines how conflicts that show up when saving are resolved.

Generally used in versions between Excel 97 and Excel Data Interchange Format file. Only saves the current active sheet. Mac text file format. Ensures that basic formatting such as tab and line breaks and characters are interpreted correctly. Windows text file format. MSDOS text file format. CSV file format for Mac platform. CSV file format for Windows platform. Excel versions from and However, as explained by author Richard Mansfield in Mastering VBA for Microsoft Office , this file format is generally compatible with Excel 95 and later versions.

Open Document Spreadsheet file format. OpenDocument Spreadsheet files can be opened using spreadsheet applications that use the OpenDocument Spreadsheet format. Formatting may be affected when saving or opening Open Document Spreadsheet files. Verify that the file has not been corrupted and that the file extension matches the format of the file. Hi Rob, I found no issues in your code, you may be using Excel This is great help thanks!

But I am trying to combine two codes but I cannot do it! I would like the macro to save the workbook as a file name taken from a cell and also save in in a certain folder location.!

Please can you help?!! Hi, Can I use a macro to save the excel file in a specific location based off of a specific cell within the document?

Also, Could I have the macro change the name of the document based off of a different cell within the same document? Yes, you can use SaveAs method of workbook to save the file with different name.

Assuming you have the file name in the Cell A1. The below code will save the active workbook in the given path with file name mentioned with the full path at A1. SaveAs will save the file with the changes in the specified location.

It will not neither close the old file nor open new file. What code do I use so that the file saves to a folder in a users My Documents. Now, the folder might not exist the first time they are saving the file, so I would need to incorporate that as well into the code. The example path did not show correctly in my initial comment. Hi, I tried several code to save my excxel file. There is data in cells of original workbook but the saved one is empty… excel Could you Have please some idea what couses this curious phenomena?

Hi to all, I am using Excel for Mac. In a macro file. My problem is that when the macro does a SaveAs, there is a dialog box telling me that the macros will be removed in the. How can I bypass that dialog and finish the save process without user intervention? Value Application. Select Application. Can you tell me how? With Application. With Destwb Select Case Sourcewb. CreateItem 0. With Destwb With OutMail. I am trying to save file RENT. End Sub I am not able to see the content in the workbook why?.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related 2. Hot Network Questions. Question feed.