Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File & Help only active menu items | Excel Discussion (Misc queries) | |||
Insrt curr file name & name of active worksheet respectively | Excel Worksheet Functions | |||
Saving an external file without making it active | Excel Programming | |||
Determine active file size | Excel Programming | |||
Save active worksheet to CSV file | Excel Programming |