Hi.
Can someone help me please? I'm trying to use a cell value within an external link address.
For instance if I have a reference like 'C:\Docs\[January.xls]sheet1'!A1
and I want to replace the January.xls part for a value from a cell in the same workbook. I can make it work using the & command but it only works when the other workbook is open.
Is it possible or am I wasting my time?
Thanks,
Jon
Bookmarks