How to insert a new reference in an excel projet

Question

Good morning,

I have a Ms Access project that creates a new Ms Excel project and inserts data into a sheet.

I need to insert a new reference in the created Excel project.

I want to insert a reference to Ms Access to be able to invoke a Ms Access form.

Is it possible to do all this from Access?

Thanks for your help

Marco Dell'Oca

Answer 1

In Access a reference can be added to the current database by calling the AddFromFile method of the References collection.  The following, for example would add a reference to the Adobe Acrobat type library: 

Application.References.AddFromFile("C:\Program Files\Adobe\Acrobat DC\Acrobat\acrobat.tlb")

I'm not very familiar with the Excel object model, but I assume you could do similar in Excel from Access through automation, by first creating a reference to the Excel file in the current database and then returning a reference to it in code in order to call the above method.

 

Answer 2

Thanks for the reply, I think I'll follow Viorel's advice as it's the easiest way.

Marco Dell'Oca