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.

ThisWorkbook.Name returns a wrong workbook name
 

Refer to the open workbook as: 'ActiveWorkbook'

ThisWorkbook always refers to the one that the copde is in

Cheers

M


wrote in message
...
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.