Let’s say that you want to run a Mathcad Prime worksheet at a specific time of day without user intervention. For example you need to generate Excel reports overnight, do some computations with the extracted data, and have the files ready first thing in the morning.
Using Windows 7 with Mathcad Prime, you can do it. This article shows you how.
Start by creating a Mathcad Prime worksheet that reads an external file generated on a schedule, does a computation, and writes the result back to the same Excel sheet:
Reading the values from the Excel file
Mathcad computes the eigenvalues and writes them back in the same Excel sheet
Next, you will need a Visual Basic script to run via Task Scheduler. PTC has already created this VB Script for the current worksheet (download the script here). To make it work for other worksheets, just open the script using Notepad and rename it.
The Script does the following:
After you have created the Mathcad worksheet and downloaded or edited the VB script, you need to tell the Task Scheduler that a new assignment is ready. Follow these steps:
Mathcad is engineering math software that helps you perform, analyze, and share all your most vital calculations. Engineers at ground-breaking companies use it, and now you can try your own free-for life-version and see what this powerful math software can do for you. Download PTC Mathcad Express today.