Excel: How to determin the name of the workbook, which contains the procedure.

[Gernot Pfeifer]

Hallo world,

I have to determin the name of the workbook, which contains the running
procedure/makro.

"activeworkbook.path" are something like this doesn't help, because it is
not sure that the procedure running _is_ in the activeworkbook (I have to
handel many workbooks the same time.

Thank you very much.
Gernot

Excel 2003

 

[Florent]

Hello,

You just have to use ThisWorkbook instead of ActiveWorkbook !

Florent

 

[Gernot Pfeifer]

Hello Florent,

thank you very much,... sometimes the things are very simple...

Salut Florent,

merci beaucoup, de temps en temps les choose sont plus facile que l'on
croit.

Gernot