Is it possible to open a specific sheet of an external workbook without referring to a cell?
This works fine but it refers to "A1" cell:
[D:\Test workbook\Book1.xlsm]'Test sheet2'!A1
And if I remove the cell, it doesn't work anymore:
[D:\Test workbook\Book1.xlsm]'Test sheet2'
http://www.mrexcel.com/forum/excel-q...ring-cell.html
http://www.ozgrid.com/forum/showthre...91125&p=727443
Bookmarks