Active File name

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

Hi,

On my current opened file, I would like to get the
filename in VBA. Something similar to this that gets the
active sheet name.

sheetname = Activesheet.Name

Thanks,
LC
 
LC,

Try ActiveWorkbook.Name or ActiveWorkbook.FullName


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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

Sheet name to cell 4
Unable to make the name Property of the Range Object Local 6
Excel crashes and restarts when accessing newly created worksheet 2
All Workbook Saved except This Workbook 3
Odd Export as PDF problem - Killing me. 6
All Workbook Saved except This Workbook - Part2 3
activesheet.name ending in "-" &Style1 2
How to determine if a chart is embedded or not 7

Back
Top