There are probably several answers depending on what you want to do. If you
want to open and control Access from Excel you would use automation:
http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL
http://support.microsoft.com/?id=260410
OFF2000: Microsoft Office 2000 Automation Help File Available
http://support.microsoft.com/?id=210111
ACC2000: Using Microsoft Access as an Automation Server
(automating any of the office programs from another office program or from
Visual Basic is identical)
http://support.microsoft.com/support...aqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic
http://support.microsoft.com/support...fdevinapps.asp
Programming Office from Within Office
http://support.microsoft.com/support...dev/iisfaq.asp
Integrating Office with IIS FAQ
http://support.microsoft.com/?id=177760
VBA: How to Run Macros in Other Office Programs
http://support.microsoft.com/?id=253338
INFO: Office Developer Samples and Tools Available for Download
if you just want to grab data from an Access MDB file you can use ADO or DAO
(don't even need to have Access installed)
http://www.erlandsendata.no/english/vba/adodao/
If you just want the program to open Access for the user to use
interactively, then you can use the Shell Command or
Application.ActivateMicrosoftApp xlMicrosoftAccess
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
"John Baker" wrote in message
...
Hi:
Is there any way to call an access db program using an excel macro?f
If so what's the command?
Best
John Baker