| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting value from an unopened file (indirectly referenced)
1. I am working on file F1 and Cell A1 contains a file name (fname).
2. I want to extract the contents of cell B2 on fname (which has not been opened!)and put it onto cell B2 of file F1. How do I do this ? - I used concatenate to evaluate '<fname but it does not work - I used Indirect function, but it works only with opened files Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want blank cell displayed if indirectly referenced value is zero | Excel Worksheet Functions | |||
| Excel - How to indirectly access a file whose name is in a cell | Excel Worksheet Functions | |||
| copying data from an unopened file programmatically | Excel Discussion (Misc queries) | |||
| Extracting Footer information from unopened XLS file. | Excel Programming | |||
| download .csv file indirectly from website - long | Excel Programming | |||
Threaded Mode
