Running Macro's Sequentially

  • Thread starter Thread starter ArizonaHeat
  • Start date Start date
A

ArizonaHeat

I am trying to run multiple Macros sequentially. My understanding was that
each Macro was completed before the next one was started, but it does not
seem to be working that way. I have one Macro that runs three other Macros:

Macro macUpdate:

RunMacro macDownloadData
RunMacro macUnZip
RunMacro UpdateTables
----------------------------------------------------------------------------
Macro macDownloadData:

RunApp "C:\Program Files\Ipswitch\WS_FTP Professional\wsftppro" -s "ARMLS
FTP:/Full Data Daily/*.*" -d local:C:\Access\ARMLSData\
-----------------------------------------------------------------------------
Macro macunZip:

RunApp "C:\Program Files\WinZip\wzunzip" -o C:\Access\ARMLSData\RES-dat.zip
c:\Access\ARMLSData\ListingData\
------------------------------------------------------------------------------
Macro UpdateTables:

OpenQuery
Clos
-------------------------------------------------------------------------------
Each of the individual Macros work correctly, but when the main
Macro(macUpdate) is executed, all three Macros (macDownloadData, MacUnZip and
UpdateTables) are executed at the same time.

I have searched Google and Microsoft Knowledge Base with no joy. Any
assistance would be appreciated.
 
Arizona,

When macros are using commands and data and processing within the Access
database or application itself, I would expect the actions to be
processed sequentially.

I would not expect that in the example you have given. The macros are
activating other programmes. Once the macro has done its job of running
the other applications, those other applications are then running
independently in their own right, and the macro action that triggered
them has no control over how long those other applications will take to
run their internal processes.

Sorry, can offer an explanation, but not really a solution that comes to
mind.
 
Back
Top