View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
roger butler roger butler is offline
external usenet poster
 
Posts: 3
Default 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