Excel VBA - Running Access Marco in Excel

[cbl1008]

Hi all,

I would like to run an Access macro in excel. Can i do that?

Thanks,
Chuc

 

[Frank Kabel]

Hi
you probably have to adapt the macro a litle bit. Depends on what kind
of macro you have in Access?

 

[cbl1008]

On a daily basis, I receive price quotes from different counterparties.
I have a macro in Access to run queries to get the results i want. The
these queries are linked to a prcing model macro in excel.

I am trying to see if I can run the access macro in excel so that
don't have to open up access and run the access macro before I analyz
the pricing model in excel.

Thanks a lot for your help.

Chuc

 

[Tom Ogilvy]

http://support.microsoft.com/?id=177760
VBA: How to Run Macros in Other Office Programs


http://support.microsoft.com/?id=210111
ACC2000: Using Microsoft Access as an Automation Server

http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download

http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available