Open Excel with Add-ins in Access

[salut]

I am trying to open Excel through Access. The problem is it will not
automatically load all those Add-Ins. Is there anyway to solve the problem?
Thanks!

The code I used to open excel is the following:

"Set oExcel = CreateObject("Excel.Application")"

 

[David Lloyd]

The Excel Application object has an AddIns collections which you can use to
load the AddIns (the Add method). The collection also has an Installed
property which you can use to install an add-in in the AddIns collection.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to open Excel through Access. The problem is it will not
automatically load all those Add-Ins. Is there anyway to solve the problem?
Thanks!

The code I used to open excel is the following:

"Set oExcel = CreateObject("Excel.Application")"

 

[yolip]

can you provide example for it?

thanks

 

[David Lloyd]

Dim xl As New Excel.Application
Dim wkb As Excel.Workbook

Set wkb = xl.Workbooks.Add()

'This loads the add-in into Excel
wkb.Application.AddIns.Add ("C:\MyAddIn.xla")

'This is the equivalent of checking the checkbox
wkb.Application.AddIns("MyAddIn").Installed = True

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


can you provide example for it?

thanks