filename

  • Thread starter Thread starter sginther
  • Start date Start date
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"
 
I want to put it into a cell within the worksheet and NOT in a footer.
Any ideas
 
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.
 
You must log in or register to reply here.

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

problems getting this macro to work 23
Using filename retrieved from GetOpenFilename 1
2 excel workbooks open up from 1 file; named :1 and :2 - why? 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Saving as variable file name 1
macro to print xps then save with name value in (B2) 8
changing the filename in a Link 1
Sheet Names and Auto-calculation 2

Back
Top