![]() ![]() ![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |