View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DonRetd DonRetd is offline
external usenet poster
 
Posts: 7
Default Trigger a Macro in MS Access from an Excel Macro?

Can an existing Macro in MS Access be triggered from an Excel Macro?
I am using Windows 98SE and Office 2000 (Excel and Access 2000).

I tried recording an Excel Macro to open up an Access data base to trigger
an existing Macro in Access. I got a message directing me to the Data drop
down menu to do a query to get data. I just want to run the Macro, not do a
query.

Can I do what I hope to do or is it not possible?
If it can be done, can you guide me to a sample of the proper code syntax?

--
IHSWRKER