Excel interface with MSDOS
Excel interface with MSDOS
(OP)
Hi,
I want to interface Excel with an MSDOS executable to export an input file, initiate the executable calculation, and import the results back to excel.
This was previously discussed in the attached thread.
Can anyone share a working macro or VB code?
Thanks
I want to interface Excel with an MSDOS executable to export an input file, initiate the executable calculation, and import the results back to excel.
This was previously discussed in the attached thread.
Can anyone share a working macro or VB code?
Thanks





RE: Excel interface with MSDOS
' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator.
Do you have an allergy to the Help system?
Cheers
Greg Locock
SIG:Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Excel interface with MSDOS
IRstuff has previously provided the VBA code, and I am capable of modifying it for a different executable.
However, having the original excel file would make interpreting what is going on much easier.
Any chance IRstuff could supply the original files: Xl_acqwm2.xls, etc.?
RE: Excel interface with MSDOS
Zona.bat ran the program and created a dummy file that Excel would look for. Something like that... It's been 10 yrs since I created that file...
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel interface with MSDOS
Z