code not showing in visual basic for excel

To see the user’s file selection captured as a variable, perform the following:

We’re still not convinced anything happened. Selecting a file and clicking Open returns us back to Excel with no action. When we run the code, we are presented with the following ( note the custom title and filters): Using the option titles to define the options, the updated code can be made more readable: Sub Get_Data_From_File()įileToOpen = Application.GetOpenFilename(Title:=“Browse for your File & Import Range”, FileFilter:= “Excel Files (*.xls*), *xls*”) Using the argument positions to define the options, the updated code will appear as follows: Sub Get_Data_From_File()įileToOpen = Application.GetOpenFilename(“Excel Files (*.xls*), *xls*”,, “Browse for your File & Import Range”) Finally, we will only display Excel files in the dialog box i.e.We will customize the title of the dialog box to read “Browse for your File & Import Range”.We will use an SET assignment statement to place the user’s selection in the “ FileToOpen” variable.This will be declared as a string data type.

We want to capture the user’s selection in a variable named “ FileToOpen”.

The following are modifications we will make to our existing code: To make this method useful, we will store the selected file in a variable then use the variable in an Open method to perform the file open operation. The act of opening the file would need to be performed by a separate piece of code. This is because the purpose of the GetOpenFilename method is to capture the name of a selected file nothing more. If we cancel the macro or select a file and click Open, nothing happens. Notice that the title of the dialog box is “Open” and the default file type filter is to display all file types. To test, run the macro to watch as Excel presents us with the Open dialog box. To use the GetOpenFilename method in a macro, start a new procedure and enter the following code. The process of presenting a dialog box to open files can be accomplished by accessing a built-in method of the Application object. Begin by opening the Visual Basic Editor by pressing ALT-F11 on the keyboard.

Code not showing in visual basic for excel