Multiple Macros within a Macro

  • Thread starter Thread starter tj
  • Start date Start date
T

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?
 
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.
 
Back
Top