I am trying to create a Metrics report in Excel 7. The data for the report is
in an MKS application History. MKS does not provide a way to collect the
history data other than using a command line interface.
I have manually typed in the command line and run it redirecting the result
to a text file. I have written a macro tha loads the text file into excel and
parses the data for the information I need.
I have to create the report weekly and would like to be able to run the
command line from the macro.
My approach is to create the command line in the macro, save as a text file
with the .bat extension, run the bat file and then load the result and parse
it for the data I need.
The piece I do not know how to do is execute the external file from the macro.

If there is a way to run a command line inside Excel that would work as well.

Thanks for any help.