| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to: obtain the filename that a module exists in, via VBA?
TWIMC,
When my Auto_Open() kicks off I need to be able to establish the file name. The reason for this is that when I'm designing my Excel Add in my file name uses the .xls extension so i refer to my file as FileName.xls but when I want to save my file as an Excel Add-in, the file extension changes to .xla, thus I need to update my reference in the code. Therefore it would good if I can obtain the file name when the Auto_Open() starts, then I don't have to manualy change the reference. Any ideas on how to accomplish this would be create. TIA KM |
| 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
