in the first part of your program (after keying in the inputs, place some code to have it open a new drawing, then load the inputs. This all depends on the language in which the program was built upon, but generally speaking, Visual Basic, and even Lisp routines run on a sequential method (FIFO...
What you did is the only thing possible in Pro-Engineer (and every CAD/CAE software I know of. The reason is although the surface may reflect a 2 dimensional output, the centroid / center of gravity / center of mass is a 3 dimensional resultant. The component must have volume (mass) in order...
You will probably want ot get a book on ACCESS. When you create tables, forms, etc., you can create relationships that allow 1 form to use data across many other forms. Within these relationships, you can set duplication abilities, date fields, etc. Pretty nice actually. Just takes a little...
No. There is not a way to hide an individual module. You can set a password protection to the VBA Project though. This will allow the developer the ability to access and manipulate the code while hiding the code from the individual users.
Short of developing VBA code, there is no way to copy a formula based cell to another worksheet without using the copy/paste special/values command.
You could create a macro and adjust the code, then create either a shortkey or an icon to accomplish the task. The problems with the macro is...
RobV,
It's been a while (I used to design natural and Toxic gas compressor systems), but ASME Section VIII, Division 1 (Boiler and Pressure Vessel code) gives that information pertainable to their codes. (It is wholly dependent on the safety factor). You could do a hoop stress calculation and...
There really isn't a way to set it to show just the macro names due to the fact that you may have macros that are named the same in different workbooks.
Not quite sure. based upon my version of MathCad, the read and write feature is for sending data to and from a DAT file, not an excel file.
If you already have the forms created in both, I would use the component and set the cells as needed.
If this is not the case, you will probably need...
HelpAng,
When you are in MathCad and are inserting the Excel Component, you get a dialog screen that allows you to link your fields. You are not stuck with "A1" as a cell. You can choose any cell(s)/Range(s) that you need.
If this doesn't help, send me a excerpt from you file and...
HelpAng,
I did a little research with the add-on and with MathCad 11 (This is the release that I use). It says that it can use range names instead of just R1C1 criteria.
If you send me your file I can see what's going on, or if your copy of MathCad is registered, you would probably be better...
Mutt,
If he has the "option explicit" checked in the VBE/options, he will see errors. Option Explicit means that all your variables have to be defined (i.e MyRange as Range, ...)
Other than that, I can't see any reason that it would give errors.
Also at the front of the sub (after...
try this code for sorting the sheets. Then add another sub to copy the cells. (Depending on the version of excel, you can code in a Refedit control that allows you to choose the range.
Sub SortSheets()
'Application.ScreenUpdating = False
'This routine Sorts the sheets of the
'Active WorkBook...
