I'm in the process of writing a COM add-in for Excel 2003 using C#, most of which is going ok. However, I have a question that I would appreciate some help with....
I need to access the ActiveWorkbook/ActiveWorks
heet when Excel opens. I thought I would be able to do this in the OnStartupComplete method. Unfortunately, the Excel.Workbooks.Count property is at zero during the OnStartupComplete method, indicating that the Activeworkbook objects of the file I am opening has not been set yet.
The add-in needs to access the activeworkbook when it opens. Can anyone suggest how this is possible? I am using the method as indicated in the following link: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q302901