HOW TO SET REFERENCE TO EXCEL LIBRARY IN ACCESS

[arni]

Please advise how to set reference to the correct excel
library that would enable
the .Document, .Sheet, .CopyFromRecordset Method/Property
of MS Access 97?

I am not yet familiar with the setting of references.

Help is very much appreciated.

arni

 

[John Nurick]

Hi Arni,

These sound like objects in the Excel object model, not in the Access 97
one. They should be accessible if you go to Tools|References and check
the "Microsoft Excel X.X Object Library", where X.X is whatever number
appears on your machine (8.0 for Excel 97).

 

[Guest]

Hi John,

I already tried but it does not activated the
methods/properties mentioned below.

thanks,
arni

-----Original Message-----
Hi Arni,

These sound like objects in the Excel object model, not in the Access 97
one. They should be accessible if you go to Tools|References and check
the "Microsoft Excel X.X Object Library", where X.X is whatever number
appears on your machine (8.0 for Excel 97).

Please advise how to set reference to the correct excel
library that would enable
the .Document, .Sheet, .CopyFromRecordset Method/Property
of MS Access 97?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

You will also have to declare and instantiate an Excel.Application
object. See e.g.:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476




Also, search www.mvps.org/access

Hi John,

I already tried but it does not activated the
methods/properties mentioned below.

thanks,
arni

-----Original Message-----
Hi Arni,

These sound like objects in the Excel object model, not in the Access 97
one. They should be accessible if you go to Tools|References and check
the "Microsoft Excel X.X Object Library", where X.X is whatever number
appears on your machine (8.0 for Excel 97).

Please advise how to set reference to the correct excel
library that would enable
the .Document, .Sheet, .CopyFromRecordset Method/Property
of MS Access 97?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.