Issue with Access / Excel - Losing AddIns

[CoffeeNow]

I am exporting several queries to an existng Excel workbook, Excel, in turn, uses the data in several formulas.

The issue I have: After I export the queries to Excel, I have Access Open the destination workbook:

Set xlApp = GetObject(, "excel.application")
xlApp.Visible = True
xlApp.Workbooks.Open MyPath & "\533 Raw Data.xls"

This works fine, but I noticed that certain functions associated with Excel's Analysis ToolPak, specifically EOMONTH. Looking at Excel's Addins, I noticed that the ToolPak option is no longer checked. Is there anyway to open Excel from Access and prevent the Analysis Tookpak from being "unchecked"?


Both Excel and Access are version 2002.


thanks in advance!

 

[PJStephenson]

Have a play with the addins property in excel, possibly as part of the open procedure. I use something similar:

AddIns.Add Filename:="PathToAddin\AddinName.xla"
AddIns("AddinName").Installed = True

HTH
Peter

 

[CoffeeNow]

Thanks for the reply.

I've been seeing some strange things with the Add-ins in addition to the case stated above (analysis toolpak not being selected)

There are instances of the analysis toolpak being selected in the addins dialog box, but the EOMonth function still returns the NAME? error. Recalc doesn's solve this problem.

I nipped this problem in the bud by adding an EOMonth function to an Access Module.

Thanks for your help!