View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
PeteCresswell[_2_] PeteCresswell[_2_] is offline
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.