Run an excel macro

  • Thread starter Thread starter Dustin
  • Start date Start date
D

Dustin

Hi,

I made it a little further than my previous post.

Is there any way Access can tell an excel macro to run
when data is added to a table in access? I have a query in
excel that enters data from access, and I need excel to
update that query everytime the table in access is updated.

Any help would be greatly appreciated,

Dustin
 
You want to run an EXCE:L macro whenever data are added to an ACCESS table?
This is not possible with ACCESS macros; you would need to write VBA code to
do something like this. However, are you sure that this design setup is
appropriate? Why do you need to run EXCEL when the data are updated? Can't
EXCEL update itself when it needs to run at some later time?
 
-----Original Message-----
Hi,

I made it a little further than my previous post.

Is there any way Access can tell an excel macro to run
when data is added to a table in access? I have a query in
excel that enters data from access, and I need excel to
update that query everytime the table in access is updated.

Any help would be greatly appreciated,

Dustin
.jack
 
Back
Top