Call Access macro using Excel VBA

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?
 
D

Daryl S

Look at the DDE commands in help (e.g. DDEInitiate, DDEExecute, etc.) That
might do it for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Macro to export table to Excel then run Excel macro 1
control Excel macro from within Access office 2002 2
Call an Access macro from an Excel macro 1
Import Individual Rows of Excel Data 4
Can I run a macro in a stored database from an open database? 1
vba macro using DDE 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top