Home » 2017 » April

Identifying all open instances of Excel

VBA’s GetObject( ) function is great for assigning an Access object variable to a single instance of Excel, but this function only identifies the first instance of Excel which was opened.  If you have multiple instances of Excel open on your desktop, then you need...

Read More »

Automating Excel from Access

Today I published Part I in a series of articles written to assist Access developers in their efforts to improve user experience when working with Excel in their applications.  Many of my clients have migrated their business processes from working primarily in spreadsheets to working...

Read More »