Use current filename as a string

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

Guest

Hello,

I want to use the current filename in a macro to indicate a certain range.
So something like this:
ActiveWorkbook.Names.Add Name:="FileName"
How do I define the current filename?
 
Activeworkbook.Name for a name such as "myWorkbook.xls"

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel VBA SQL Query Filename 3
Save a pdf to the desktop with a filename as a cell reference 2
Directory Name - IF Named Range Exists 0
Cell reference to determine filename 1
Move all except latest to another folder 2
Excel to PDF or XPS boilerplate routines 3
Macro needs updated Range name addresses 3

Back
Top