Retrieve data from another workbook using a cell value as file path.

[kingpin1984]

Hi Guys,

I have an equation in A1 whose formula result is a text string for a file destination.
In A2 I want to be able to retrieve the value from cell B1 in that file in cell A1.

I assume that VBA is required to do this which I dont have a problem using but dont actually know where to start!

Thanks.

 

[Andrew Poulsom]

Please post a sample formula which includes the path to the external workbook.