XL97: Macro to Open the Most Recently Used File

MORE INFORMATION

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.

Sample Macro

1. Save and close all open workbooks, and then open a new workbook.
2. Start the Visual Basic Editor by pressing OPTION+F11.
3. On the Insert menu, click Module.
4. Enter the following code in the module:

         Sub Open_Last_Used_File()
   
            Dim S as String
   
            ' Set the variable S to the path and file name of the most
            ' recently used file.
            S = Application.RecentFiles(1).Name
   
            ' Open the file.
            Workbooks.Open S
   
         End Sub
   						

Running the Sample Macro

NOTE: If you do not select the "Recently Used File List" check box and you run a macro that uses the RecentFiles property of the Application object, the following error message appears: To prevent the message from appearing when you run the Open_Last_Used_File macro, select the "Recently Used File List" check box on the General tab of the Preferences dialog box, and click OK.

1. On the File menu, click "Close and Return to Microsoft Excel."
2. On the Tools menu, point to Macro, and click Macros.
3. Click the Open_Last_Used_File macro in the list of macros, and click Run.

When you run the macro, it opens the first file in the list of recently used files, which is the file you most recently opened.