Macro to open most recent workbook

[Xx7]

Would like to find a macro that opens the most recent workbook. Any help appreciated!!

[MarvinP]

Hi Xx7,

Looking in the Object Browser for the word Recent landed me this code:

Application.RecentFiles(1).Name

Use the above in a macro that opens a file and see what happens.
I'd bet if you changed the 1 to a 2, you'd open the second most recent file.

hope that helps

[nimrod]

Cool.. Thx Marvin. Your right .. you can enter a number to open a different file ... Thx.

Public Sub Demo()
   On Error Resume Next
   Application.RecentFiles(Application.InputBox("Enter Numer", "open book", 1, , , , , 1)).Open
End Sub

[Xx7]

Beauty... thx!!