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