compile error User-defined type not defined Set objXL = New Excel.Application

Hi All,

I am fairly new to Access VBA. In Access I am trying to set a command button to run a Module. I am currently using a Macro to accomplish this (openvisualbasicsmodual >Modual Name: "Module1" > Procedure Name: "sCopyRSToNamedRange")

This Macro is only opening the Module. I need a command to run the module

I need the following code to export the table data to an existing, saved excel file. It would have to start inserting in Column C Row 3 and insert the table rows down from there.

The Module is giving me a Compile error User-defined type not defined on VBA line Set objXL = New Excel.Application in the following Code:

Please Login or Register  to view this content.

Thank you for Any help you can give on this.

Thank You, that did work however now I receive Run time error '429': ActiveX component can't create object:

Please Login or Register  to view this content.

The end goal of this module will be to get the excel workbook to open from a specified location and insert the Access table data into the excel sheet1 in text format starting at Column C Row 3.