Calling Access Program from Excel

J

John Baker

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
 
T

Tom Ogilvy

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/OfficeDev/FaqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic


http://support.microsoft.com/support/OfficeDev/offdevinapps.asp
Programming Office from Within Office

http://support.microsoft.com/support/officedev/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
 
Top