The Excel.Application class 1

[Timinator]

Do I have to add any componets or anything to access the Excel.Application class? VB doesn't allow me to Dim a variable with the Excel.Application. I have excel 97 installed if that matters.

I'm trying to export data from a recordset to an excel spreadsheet. If anyone knows an easy way to do this let me know.

Thanks. Tim

 

[daimaou]

Add a reference to Microsoft Excel 8.0 Object Library and it should work, let me know if you're having more problems.

 

[Timinator]

daimaou,

How do I add the reference to the Microsoft Excel 8.0 Object Library?

Thanks.

Tim

 

[ixian]

Tim,

Go to project and scroll down to Reference and Click
a box will open, scroll down to Microsoft Excel Object and tht will add in the Excel library, for the programming for it