ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Question - Excel to Access and back again (https://www.excelbanter.com/excel-programming/375479-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

Ron de Bruin

Macro Question - Excel to Access and back again
 
Maybe this will help Mike
http://www.rondebruin.nl/accessexcel.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"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 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com