Excel Add-Ins

[serge]

Hello,

I would like to open from an Access database, an excel file which uses
Add-ins (reuters add ins in fact). If I open the excel directly, the Add-In
is automatically set up which is fine. If I try to open my file through an
access form, it doesn't work: The excel Add ins are not available. Below is
the code I use:

Dim xlApp As Object

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Open ("C:\etsreports\etsreports\dataprice.xls")
xlApp.DisplayAlerts = False

Using this code, the reuters add-in is not loaded.

I tried to use Hyperlink as well but without success.
Any help on this ?

Thanks,

Serge

 

[Jeanette Cunningham]

serge,
would you explain what you are expecting to do once you open the file
through access.


Jeanette Cunningham

 

[serge]

Jeanette,

Once the excel file is open (through Access), some cells would be updated
(thanks to the add-in). Then a macro would be run and the file closed.

I need the add-in to update the Excel file and I would like to launch that
update from an Access database.

Serge

 

[Jeanette Cunningham]

serge,
this is something that I haven't tried.
Can you write a macro in excel that would use the add-in to update the
cells, and call the macro to run from the code that opens excel.


Jeanette Cunningham

 

[serge]

Jeanette,
Thanks for your help. That's another idea I am trying to investigate but I
don't know the VB code for that. Do you know how to call an add in from Excel
?

Serge

 

[Jeanette Cunningham]

Try it this way.
Open excel and write a macro that will make the excel add-in do its stuff.
Put code in the Open event of the workbook that will run the macro when the
workbook opens.
Now open the workbook from access.



Jeanette Cunningham