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