ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel VBA - Running Access Marco in Excel (https://www.excelbanter.com/excel-programming/309665-excel-vba-running-access-marco-excel.html)

cbl1008

Excel VBA - Running Access Marco in Excel
 
Hi all,

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

Thanks,
Chuc

--
Message posted from http://www.ExcelForum.com


Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

"cbl1008 " schrieb im
Newsbeitrag ...
Hi all,

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

Thanks,
Chuck


---
Message posted from http://www.ExcelForum.com/



cbl1008[_2_]

Excel VBA - Running Access Marco in Excel
 
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

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Excel VBA - Running Access Marco in Excel
 
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

--
Regards,
Tom Ogilvy

"cbl1008 " wrote in message
...
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. Then
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 I
don't have to open up access and run the access macro before I analyze
the pricing model in excel.

Thanks a lot for your help.

Chuck


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com