Opening another file with title equal to a cell entry

[baron11]

Hi, I want to create a macro that opens a file from a folder with name equal to a cell entry in the spreadsheet. For example, I have a file named 02.09.2009.xls on the network. I enter this date in a spreadsheet named entry.xls and everytime I run the macro in entry.xls, it opens up the 02.09.2009.xls, which is my entry in a cell in extry.xls

Please help.

thanks.

Baron

[lucas]

 
Option Explicit
Sub OpenExcelFile()
On Error GoTo 1
ActiveWorkbook.FollowHyperlink (ActiveWorkbook.Path & "\" & Range("B2") & ".xls"), NewWindow:=True
Exit Sub
1: MsgBox Err.Description
End Sub

the dated file has to be in the same directory as your entry.xls or change it in the code. Change range b2 to suit.

[baron11]

Thanks.