S
sginther
How can I insert a a filename into that workbook
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MAX258
It depends on where you want to insert the filename, but you can alway
do it in the Header or Footer. Go to File/Page Setup and select th
Header/Footer tab. Select Custom Header, and from the icons choos
"Insert Filename"
do it in the Header or Footer. Go to File/Page Setup and select th
Header/Footer tab. Select Custom Header, and from the icons choos
"Insert Filename"
S
sginther
I want to put it into a cell within the worksheet and NOT in a footer.
Any ideas
Any ideas
M
MAX258
This is from Frank Kabel in a response to someone else's post on the
same question in the Excel General forum.
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
I tried it and it works great. Just copy/paste this formula.
Frank also advised that the file has to saved/named before doing this.
same question in the Excel General forum.
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)
I tried it and it works great. Just copy/paste this formula.
Frank also advised that the file has to saved/named before doing this.
S
sginther
THANK YOU VERY MUCH!!!