Microsoft KB Archive/187653

= XL97: Macro to Open the Most Recently Used File =

Article ID: 187653

Article Last Modified on 6/17/2005

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q187653



SUMMARY
If you click to select the "Recently Used File List" check box on the General tab of the Preferences dialog box in Microsoft Excel 98, the files you used recently are listed on the File menu. This article contains a sample macro that you can use to programmatically open the file you used last.



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
 Save and close all open workbooks, and then open a new workbook. Start the Visual Basic Editor by pressing OPTION+F11. On the Insert menu, click Module.  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:

Run-time error '9':

Subscript out of range

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.

