Active File name
 

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

Active File name
 

LC,

Try ActiveWorkbook.Name or ActiveWorkbook.FullName


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"LC" wrote in message
...
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