How can I run an access macro from excel?
 

In Excell 2003 I have several macros that pull data from and access data
base. This is fine except I have to run a macro in access to update that data
base first. Is there a way to run the access macro from within excel with an
excel macro?

How can I run an access macro from excel?
 

http://groups.google.com/group/micro...3a0ded372f0cba

Hth,
Merjet

How can I run an access macro from excel?
 

WOW! you must have just been there. Thanks

"merjet" wrote:

http://groups.google.com/group/micro...3a0ded372f0cba

Hth,
Merjet

How can I run an access macro from excel?
 

D'oh! Sorry, realised I need to use the Quit action / method & obviously, it
now works! Having a dozy moment this morning I think!


Regards,

Steve


"Kamehameha" wrote:

Hi,

The code via this link is massively helpful, I've been able to use it to run
an access VBA Procedure from Excel and am v impressed with that. I do have an
issue though that I don't seem to be able to solve. When the Access macro has
completed, my code returns to Excel & I want to close the instance of Access
running on my machine - how do I do it?

a.Close

doesn't work and comes up with an error. (Where a is an Object in the code
representing Access). Any ideas?


--
Regards,

Steve


"RocketMan" wrote:

WOW! you must have just been there. Thanks

"merjet" wrote:

http://groups.google.com/group/micro...3a0ded372f0cba

Hth,
Merjet