Microsoft Access - need a macro to export a query/queries from Access to Excel?

Asked By Praveen Chennupati on 25-Apr-13 07:41 AM

Hi,

I am looking for a macro where in I can get a set of queries to export to excel.

I dont have enough knowledge on macros. so kindly give the full macro.

Best regards,
Praveen.

Robbe Morris replied to Praveen Chennupati on 25-Apr-13 08:56 AM

Are you trying to convert stored queries in Access to new macros in Excel? Or, are you attempting to execute the stored queries in Access and load the data into Excel?

Praveen Chennupati replied to Robbe Morris on 25-Apr-13 09:36 AM

second option would work for me...

Robbe Morris replied to Praveen Chennupati on 25-Apr-13 09:47 AM

The simplest option might be to turn on Excel's Macro recorder and see if you can execute the process manually. If it is possible for you to do it manually, then the recorder should be able to pick up what you did and generate VBA code for it.