Hi I am working on an automation tool that will allow users to enter a bunch of design variables into a web app, which then interfaces with Mathcad and returns some answers along with an html copy of the worksheet. The interface uses a custom piece of code to interface with the API, however all commands are driven from an XML file. Essentially the program does the following: Open Worksheet Set Values Save as .xmcd Save as .html Read Val Close Worksheet I would like to be able to hide certain sections of the worksheet from the cody displayed to the users, mainly the sections that read data files and perform lookups etc, but also the section where all input variables are defined. I have done this using 'areas' on the sheet. The automation again works fine when these areas are open, however it fails when the areas are closed, returning an error message saying it cannot find the 1st variable I try to define. I am assuming this is because the software I am using to set the values is essentially doing a 'find and replace' on the variable names, and so if the variable is hidden it cannot find it. Ideally I would like to avoid putting the function definitions etc to the right of my calculation in order to hide it, so is there a way to open / close areas usingthe api, or can anyone think of a better alternative to using areas to hide data? Thanks Jamie
