View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.com.add_ins
mike dilworth mike dilworth is offline
external usenet poster
 
Posts: 2
Default OnStartupComplete and activeworkbook

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