Filename in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get only the filename of the active workbook into a cell.
The "CELL" function returns the name including the whole path.
 
Public Function getfilepath()
getfilepath = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
End Function

create the the above function and call from your cell by using

formulae =getfilepath()
 
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

Vlookup and return sheet name also 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
This function returns incorrect value sporadically 1
Workbook Name Edited in Cell 1
How can I show the current file name in a cell. 3
File name insertion in cell 3
Name Cell or Worksheet 2
using the Cell function 2

Back
Top