Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling an application from excel vba
I have a old Fortran based application where I calculate thermodynamic
properties. It runs in a window, but is definitly not window complient (menu driven, but has short cuts like Ctl + Ins to copy, Shft + Ins to paste) The interface/output from this application are text files The only ouput is a Txt file - 265 pages long The input files are also Txt files, where I change parameters to vary what will be calculated - after which I "run" the program and it generates the text files So I built a excel spreadsheet to pull the text files and convert them into spreadsheets -where I can analyse the data I also wrote macros to take data from my Excell files and rewrite the input text files I would like to go the next step, and get Excel to Open this application Open a specific file Run the file and close Can anyone point in a direction to learn how to do this Thanks -- Mike Matheson Canada |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to close excel application other than application.quit | Excel Programming | |||
controlling another application via VBA code in Excell & sending keystrokes & mouse clicks | Excel Programming | |||
Controlling Outlook from Excel Using VBA | Excel Programming |