Running Excel via batch mode from another program
Running Excel via batch mode from another program
(OP)
Has anyone successfully done this? What I'd like to do is to call Excel from Ansys (my FEA program). I would need to read in values from a text file into excel and then export the output data from excel. I have envisioned doing this via macro but I would like to do this without opening the Excel GUI. Is this possible? I didn't see anything about batch mode in the Excel help.
Thanks in advance!
-Brian
Thanks in advance!
-Brian





RE: Running Excel via batch mode from another program
Why not just save as .CSV format?
TTFN
RE: Running Excel via batch mode from another program
-Brian
RE: Running Excel via batch mode from another program
TTFN
RE: Running Excel via batch mode from another program
Interesting...how does one go about executing an auto_open macro?
Thanks for all of your help!
-Brian
RE: Running Excel via batch mode from another program
RE: Running Excel via batch mode from another program
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Running Excel via batch mode from another program
For example, I used to use Excel to generate input files to the old FAST2 program (used as basis for Welding Research Council bulletin 207), then run FAST2 using the "Shell" command. Then take the output file(s) and perform further processing for stresses and condensed/summarized reports. Nowadays my work doesn't call for this so much.