I have on average 30 to 40 large Mathcad Prime 8 worksheets that must sequentially open, calculate using input numbers from an ASCII text file, output an ASCII text file for input by the next worksheet, then save and close before the next worksheet is opened. This is very labor intensive and I need to automate the process with a Visual Basic program. It is critical that each worksheet recalculate while it is open, to deliver correct and updated results to the next worksheet. I can get the attached example VB program to start Mathcad and open a single file, but I have not been successful in adding lines of VB code, that recalculate that worksheet after it is opened, and then save & close that worksheet with the changes, before opening the next worksheet - and doing it all again. Help! Obviously, I am not a programmer!
