Excel Add-Ins

  • Thread starter Thread starter serge
  • Start date Start date
S

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
 
serge,
would you explain what you are expecting to do once you open the file
through access.


Jeanette Cunningham
 
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
 
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
 
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
 
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
 
Back
Top