Link a file to worksheet
 

I'm trying to open a worksheet depending on the month that the data is for.
For example, If I am looking at Jan Balance sheet on my first tab, I'd like
to pull the Jan Trial balance from a file. I have written a VLookup so that
the proper path/filename is displayed. How do I get Excel to open the file
name in cell A1?

Thank you.

Link a file to worksheet
 

Here's a little macro that will do it.........

Sub OpenFilenameInA1()
Worksheets("sheet1").Select
Workbooks.Open FileName:=Range("a1").Value
End Sub

Vaya con Dios,
Chuck, CABGx3



"Stacie" wrote:

I'm trying to open a worksheet depending on the month that the data is for.
For example, If I am looking at Jan Balance sheet on my first tab, I'd like
to pull the Jan Trial balance from a file. I have written a VLookup so that
the proper path/filename is displayed. How do I get Excel to open the file
name in cell A1?

Thank you.