How to Use Excel Addins from VB

[SeanGriffin]

I'm attempting to run an Excel macro from a spreadsheet that references some excel addins. When starting excel from the shortcuts or the executable this macro works fine. When I start Excel from my VB application I can't run the macro because it can't find the functions that are in the addins.


Can anyone tell me how to get the addins loaded when starting from my VB application so I can run this macro?

-Sean

 

[CCLINT]

Are you using the Excel Object library?

 

[SeanGriffin]

CCLINT,

I'm not sure I understand your question. But to access Excel from VB I've added the Excel refernce and use this code:

Dim xlApp As Object
Dim xlBook As Object

Set xlApp = CreateObject("Excel.Application&quot
Set xlBook = xlApp.Workbooks.Open(sFileName)

I then use xlApp and xlBook to control Excel.

-Sean