I'm attempting to get my Excel VB code to open an Access Database.
Everything I try wants to use Access as an object in Excel. I just want it
to open it. Here's some background.
Excel code is creating data and saving an .xls file I use as an import into
my Access DB. My DB has an AutoExec command to manipulate and distribute. I
want the Excel VB to Open the Access DB after it creates my .xls.
Any help is appreciated. Thanks.