Using INDIRECT in Excel 2010 linking to another workbook
Posted on 2012-08-15
I am wondering if anyone can help me please.
I have successfully been able to use the INDIRECT function to access a worksheet within the same workbook using the below syntax:
where A1 contains the name of the worksheet in question.
I would now like to access a worksheet within a different workbook and am trying to use INDIRECT for the same reason.
I have been on a number of sites, including Microsoft's site but the syntax that I am trying to use does not work:
This is my latest syntax:
A1 contains "\\ipaddress\subfolder\file.xlsx"
A2 contains "Sheet1"
A3 contains "B3"
Any help would be most appreciated.