Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel interface with MSDOS 1

Status
Not open for further replies.

barilko

Mechanical
Joined
Aug 7, 2001
Messages
17
Location
US
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
 
' In Microsoft Windows:
' 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 for tips on how to make the best use of Eng-Tips.
 
No allergy to the help system, just a general lack of VB programming knowledge. I do dislike re-inventing the wheel.

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.?
 
Can't find that specific file, but the attached should have the similar basic routine in RunFlir92 in Module 1.

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
 
 http://files.engineering.com/getfile.aspx?folder=aad6a3a0-e448-4b79-b3ca-bf0c3a900166&file=FLIRDATA_with_FLIR92_updated_macros.XLS
IR, your past comes back to haunt you again! I always love referencing old, old designs, especially when new tools will still read the old formats.

Z
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top