| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.Name returns a wrong workbook name
I am using Excel 2003 and an addin I have written. When I use
ThisWorkbook.Name in my code, it returns the name of the addin, not the name of the workbook I have open. How can I get the name of the workbook, not the addin? Many thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ThisWorkbook.Name returns a wrong workbook name
ThisWorkbook will always refer to the workbook where the macro is.
You can use ActiveWorkbook.Name to return the name of the active workbook. Regards, Per skrev i meddelelsen ... I am using Excel 2003 and an addin I have written. When I use ThisWorkbook.Name in my code, it returns the name of the addin, not the name of the workbook I have open. How can I get the name of the workbook, not the addin? Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ThisWorkbook.Name returns a wrong workbook name | Excel Programming | |||
| VBA Sum returns Wrong Format | Excel Programming | |||
| Row() function returns wrong row and more.. | Excel Worksheet Functions | |||
| SUM returns wrong result | Excel Worksheet Functions | |||
| ?thisworkbook.VBComponents(5).Type returns 2 | Excel Programming | |||
Linear Mode
