Excel directory formula question?
Excel directory formula question?
So I have this formula:
='C:\Users\XXX\Documents\Debug\F1\203\…
I have to replace the "203" folder in the file directory for 60 rows about 30 times with different folders. I don't want to do this manually :s
Is there a formula to allocate a cell which Excel will reference for the name of the folder it should be going to for the file?
yes you could do it in a macro
yes, i know u could use a macro but how?Originally Posted by rcm
Yes!
However, for the function to work all the files you link to must be open!
This is usually not desirable.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I'll be fine, don't worry. Please provide the formula.
Show us the full path to the file/sheet/cell you want to link to.
='C:\Users\XXX\Documents\Debug\F1\203\[CDS-Percentx.csv]CDS-Percentx'!$G$200
='C:\Users\XXX\Documents\Debug\F1\203\[CDS-Percentx.csv]CDS-Percentx'!$G$200
So the full path is this -
C:\Users\XXX\Documents\Debug\F1\203\CDS-Percentx.csv
Let's assume cell A2 = the folder name like 203.
=INDIRECT("'C:\Users\XXX\Documents\Debug\F1\"&A2&"\[CDS-Percentx.csv]CDS-Percentx'!$G$200")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
schill2 
Register To Reply
Bookmarks