ExcelBanter - Macro Question - Excel to Access and back again

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro Question - Excel to Access and back again (https://www.excelbanter.com/excel-discussion-misc-queries/115119-macro-question-excel-access-back-again.html)

Mike The Newb

Macro Question - Excel to Access and back again

Is it possible to create an Excel Macro that opens two Access Queries, pastes
the results into two specific Excel Tabs and then closes Access down?

If so, any insight on what it would look like?

Regards,
Mike

Jim Rech

Macro Question - Excel to Access and back again

Do a search on Excel and ADO.

--
Jim
"Mike The Newb" wrote in message
...
| Is it possible to create an Excel Macro that opens two Access Queries,
pastes
| the results into two specific Excel Tabs and then closes Access down?
|
| If so, any insight on what it would look like?
|
| Regards,
| Mike
|

All times are GMT +1. The time now is 07:32 PM.