Link a file to worksheet

  • Thread starter Thread starter Stacie
  • Start date Start date
S

Stacie

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column link 2
Combine VLOOKUP and HLOOKUP's capabilities 9
Pulling Last Balance 3
Creating a link from cell values 8
how do I get a macro to change a cell in multiple worksheets? 1
Linking Formulae Across a Workbook 2
Excel 2003 Referencing multiple worksheets 3
Use Workbook tabs in a Worksheet 1

Back
Top