LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 56
Default Running MS Access From Excel VBA: Communication BetweenProcesses?

On May 28, 10:14 am, "Charles Williams"
wrote:
Why not just run queries in the jet MDB using DAO or ADO from Excel VBA?
Then the Import button is in control and you can do progess messages as
required.
And of course it will be faster since you don't have to create an instance
of Access.

Charles


Sounds like the answer to "can I push/pull messages from the MS Access
app.." is no.


That being the case, now I see the light.... and next time... or if I
get some breathing space on this one... I'll decompose the .MDB
processing into many callable routines and then call them one-by-one
from the Excel VBA.
 
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 VBA from Excel Chergh Excel Programming 1 May 21st 07 10:37 AM
How many excel processes can you open? Stanley Excel Programming 3 July 17th 06 12:19 PM
Access/Excel Communication andysgirl8800[_7_] Excel Programming 1 May 26th 06 06:36 PM
Getting Access Error Messages when running Access through Excel Dkline[_2_] Excel Programming 0 October 12th 04 09:35 PM
Multiple Excel Processes MDW Excel Programming 2 September 7th 04 05:53 PM


All times are GMT +1. The time now is 06:50 AM.

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

About Us

"It's about Microsoft Excel"