interrogating a workbook WITHOUT opening it from VBA
Hi All
A few years ago i remember reading that it is possible
to "get at" values stored in another workbook from VBA,
without having to open that workbook. It went something
like :
range("c:\myfile.xls[Sheet1]!D2") etc etc
Can someone remind me how to do this?
Thanks
Rog
|