Filename in formula bar

  • Thread starter Thread starter yee ven
  • Start date Start date
Y

yee ven

How do you refer filename1 to a cell in the formula bar?
Example:

='\\Year 2004\September\[_filename1_.xls]sheet1'!$A$1

A | B
1 |
2 | filename1
3 |
4 |

="\\Year 2004\September\["_B2_".xls]sheet1'!$A$1
will not work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell refering filename in formula bar 2
copy formula+value 2
Export Only Values 7
Can you auto edit file names inside a formula 2
Variable in a filename reference in Excel 2000 1
External Links with the same filename? 6
Excel Import Comments 3
automatic linking to many files 5

Back
Top