| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interrogating cells by cell formatting | Excel Worksheet Functions | |||
| Interrogating Data in Excel | New Users to Excel | |||
| Interrogating format | Excel Programming | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
Threaded Mode
