Macro use file address that is in cell in worksheet

[cizzett]

Is it possible to use the file address that is in a cell in the worksheet instead of actually having the file address in the macro for the file we are accessing to get data from?

In other words If I wanted to get data from another file I could paste the address into cell B2 for example on the File Reference sheet and the macro would use that file address.

 

[Fluff]

As long as you have the full path & filename in the cell, you can use something like

Workbooks.Open Sheets("Sheet1").Range("A1").Value