Opening an Excel file with an Add-in

[Susan Kobayashi]

I need to open up an excel file that has API formulas in it, let the data fill in and save it. Starting with just the file opening step, I use the following code:

Sub OpenExcelFile_Click()

Dim objXLApp As Object
Dim objXLBook As Object
Set objXLApp = CreateObject("Excel.Application")
Set objXLBook = objXLApp.Workbooks.Open("C:\Corp Info.xls")
objXLApp.Application.Visible = True

End Sub

The problem is that the key add-in I need somehow doesn't open when I do this so all of my API formulas show up as "NAME?". If I open up Excel or the spreadsheet manually all is fine. How do I specify that a specific add-in open with the spreadsheet?

Thanks.