Try
..\filename.xlsx#worksheetname!A1

and, it the worksheet name contains a space, put it in quotes
..\filename.xlsx#'worksheet name'!A1

or use a defined name
..\filename.xlsx#rangename


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup