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