| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to: obtain the filename that a module exists in, via VBA?
Is this what you want?
With Extension: ============================= ThisWorkbook.Name Without Extension ============================= Left(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".") - 1) -- Rick (MVP - Excel) "ch" wrote in message ... Hi Tom, How can we return a workbook's file name with and without extension? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
| Run worksheet module code from workbook module? | Excel Programming | |||
| Calls from sheet module to ThisWorkbook module | Excel Programming | |||
| Check if filename exists. | Excel Programming | |||
| Variable from a sheet module in a class module in XL XP | Excel Programming | |||
Threaded Mode
