Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Refresh Error when calling Excel Macro from VB.NET program | Excel Discussion (Misc queries) | |||
calling access data from excel | Excel Discussion (Misc queries) | |||
calling a C++ program from Excel 2000 and passing a result from C++ back to an excel spreadsheet | Excel Discussion (Misc queries) | |||
Converting Access dll calls to Excel program | Excel Programming | |||
How disabling sounds when calling a shell program? | Excel Programming |