Exporting a query > 65K records

A

AmandaM

Hi -

I'm pretty new to macro's. I need to export the results of a query to an
excel sheet but on occasion the results are greater than 65000 records. How
do I get the macro to complete the export on the second sheet of the workbook
in those instances?

I did see some other posts regarding exporting to multiple sheets, but they
were a little over my head.

Any help is appreciated.
 
Top