Hi MIke,
"OnStartupComplete" get fired when your add-in gets loaded in Excel
instance then your workbook loads in Excel.
You can get the name of the workbook in "WorkbookOpen" event of
Application Object.


Vinit

hi Vint

yes indeed you can. Although as I am doing this from a COM add-in in c++
its quite a bit of work to have to implment connection point etc.

the funny thing is that if I open the workbook directly i can get the name,
but if i open the workbook via a shortcut I dont get the workbook.

I can see that from a shortcut excel is opened with the /e switch and it
seems that excel opens, the StartupComplete is fired and then the workbook
loads. Whereas if you open the workbook directly (not a shortcut) then the
workbook is loaded before OnStartupComplete is called.


mike


"Vinit" wrote in message
oups.com...
Hi MIke,
"OnStartupComplete" get fired when your add-in gets loaded in Excel
instance then your workbook loads in Excel.
You can get the name of the workbook in "WorkbookOpen" event of
Application Object.


Vinit