ExcelBanter - using Excel vba to open Access query in DesignView

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - using Excel vba to open Access query in DesignView (https://www.excelbanter.com/excel-programming/435687-using-excel-vba-open-access-query-designview.html)

MikeF[_2_]

using Excel vba to open Access query in DesignView

Am looking for a simple sub in Excel to open an Access database -
d:\database.accdb - then open a query - "accessQuery" - in design view.

References to Access and DAO are installed.

Can anyone assist?

Thanx in advance.

- Mike

All times are GMT +1. The time now is 09:41 AM.