Multiple Macros within a Macro

[tj]

I have created a macro that runs 2 macros.
The first executes a batch files that takes 14 ASCII files
(with non-Access compatible extension), combines into one
file and renames the extension to .txt.
This takes several seconds.

The second SHOULD import the .txt file into a table.

The import does not happen. I think the second macro is
attempting to run before the first has completed. No error
message or anything. The import macro runs perfectly if
you execute it independently.

Any ideas?

 

[Steve Schapel]

Tj,

The only way I know of around this is to use a SetValue action at the
end of the first macro, to set the TimerInterval propeerty of a form
which is open at the time you are running this procedure, to for example
5000 (i.e. 5 seconds), and then assign the second macro separately on
the On Timer event of the form.