Call Access macro using Excel VBA

  • Thread starter Thread starter excelCPA
  • Start date Start date
E

excelCPA

I have a spreadsheet that is connected to an Access database using the
“Get External Data” feature of Excel.

The Access database has simple macro that executes to refresh the data
used by the queries. Right now, whenever I want to refresh the tables
in Access, I have to open the database and run the macro, then close
it and refresh my Excel spreadsheet, which in turn pulls from the
Access database.

Is there a way I can use Excel VBA to execute the macro in my Access
database directly from Excel?
 
Look at the DDE commands in help (e.g. DDEInitiate, DDEExecute, etc.) That
might do it for you.
 
Back
Top