Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default 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/


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Access-to-Excel Automation.... Bob Barnes Excel Discussion (Misc queries) 2 June 16th 06 08:57 PM
Running an Access Query From Excel Paul Smith[_3_] Excel Programming 0 August 17th 04 11:16 PM
Running A Access Macro From Excel Frank Excel Programming 2 August 12th 04 06:43 AM
Running Macros in Access from Excel Simon Dowse Excel Programming 1 June 7th 04 03:48 PM
Running Access MAcros or VB modules in Excel Nick Excel Programming 0 October 28th 03 06:27 AM


All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"