If your VBA procedure needs to ask the user for a filename, you could use the InputBox function and let the Excel user do some typing. An input box usually isn’t the best tool for this job, however, because most users find it difficult to remember paths, backslashes, filenames, and file extensions. In other words, it’s far too easy to screw up when typing a filename.

1. Give More Feedback
2. Getopenfilename Default File Pathways
3. See More On Stackoverflow

For a better solution to this problem, use the GetOpenFilename method of the Application object, which ensures that your code gets its hands on a valid filename, including its complete path. The GetOpenFilename method displays the familiar Open dialog box (a dead ringer for the dialog box Excel displays when you choose File → Open → Browse).

Getopenfilename Default File Pathway In Word. VBA Excel Getting File Path (ends with folder)From a previous question I know how to go about letting the user click on a. In the same batch were created through the identical pathway and did. FileName = Application.GetOpenFilename('NHK Files,.nhk,All Files,.'. Selecting this will make the program default to saving in the 'Image Files' folder as specified on the 'File Locations' tab. This allows for automated reads when using an auto loader device. This is used for HD DVD media. When enabled, the target of. LNK files is added to the compilation rather than the LNK file itself.

The GetOpenFilename method doesn’t actually open the specified file. This method simply returns the user-selected filename as a string. Then you can write code to do whatever you want with the filename.

The syntax for the GetOpenFilename method

The official syntax of the GetOpenFilename method is as follows:

GetOpenFilename method takes the optional arguments below.

Give More Feedback

A GetOpenFilename example

The fileFilter argument determines what appears in the dialog box’s Files of Type drop-down list. This argument consists of pairs of file filter strings followed by the wildcard file filter specification, with commas separating each part and pair. If omitted, this argument defaults to the following:

Notice that this string consists of two parts, separated by a comma:

and

The first part of this string is the text displayed in the Files of Type drop-down list. The second part determines which files the dialog box displays. For example, *.* means all files.

The code in the following example opens a dialog box that asks the user for a filename. The procedure defines five file filters. Notice that the VBA line-continuation sequence is used to set up the Filter variable; doing so helps simplify this rather complicated argument.

Here is the dialog box Excel displays when you execute this procedure. The appearance may vary, depending on the version of Windows you use and the display options you’ve set.

In a real application, you would do something more meaningful with the filename. For example, you might want to open it by using a statement such as this:

Notice that the FileName variable is declared as a Variant data type. If the user clicks Cancel, that variable contains a Boolean value (False). Otherwise, FileName is a string. Therefore, using a Variant data type handles both possibilities.

When you first start using Microsoft Excel 2010, Excel wants to save files in the Documents (Windows 7 or Vista) or the My Documents folder (Windows XP) under your user name on your hard drive. So, for example, the directory path of the default folder where Excel 2010 automatically saves new workbook files on a computer running Windows 7 or Vista is

However, the directory path of the default folder where Excel 2010 automatically saves new workbook files on a computer running Windows XP is

Getopenfilename Default File Pathways

The generic Documents or My Documents folder may not be where you want new workbooks you create to be automatically saved.

To change the default file location to another folder on your computer, follow these steps:

See More On Stackoverflow

1. Click the File tab and then click Options.

   The Excel Options dialog box appears.

2. Click the Save tab.

   The Save options appear in the right pane.

3. Click in the Default File Location text box.

4. Edit the existing path or replace it with the path to another folder in which you want all future workbooks to be saved.

5. Click OK.

   The Excel Options dialog box closes. The next time you save a new workbook file, it will be saved to the default file location you specified — unless you change the folder location in the Save As dialog box.