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
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.
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.