|
如何用VBA获取当前活动的excel的文件名,不含路径和扩展名
- '获取当前活动的excel的文件名,不含路径和扩展名
- Sub GetFileName()
- Dim FileName, FileName1
- ' 获取其他工作薄的名称,需要先使其活动 工作薄名.Sheets(1).Activate
- MsgBox ActiveWorkbook.Name '含扩展名
- MsgBox Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4) '不含扩展名(4位扩展名,*.xls)
- FileName = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4)
- MsgBox Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 5) '不含扩展名(5位扩展名,*.xlsx或*.xlsm)
- FileName1 = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 5)
- End Sub
复制代码
|
|