Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by asmenut

  1. asmenut

    how do I explode and modify individual text characters

    Only thing I know of is Explode Text within the express tools.
  2. asmenut

    starting new drawing

    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...
  3. asmenut

    Finding component in assemblies

    YOU WOULD NEED INTRALINK IN ORDER TO DO A SEARCH OF THIS TYPE.
  4. asmenut

    Wildfire materials libraries

    Cut and Paste this link into you Internet Explorer http://www.proecentral.com/portal/files/dirSub.asp?catid=8&subid=39
  5. asmenut

    Surface Centroid

    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...
  6. asmenut

    Inserting Data in Microsoft Access

    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...
  7. asmenut

    VBA Module Protection by hiding or password

    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.
  8. asmenut

    Protecting Worksheet

    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...
  9. asmenut

    Pipe wall calculation spreadsheet

    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...
  10. asmenut

    Macro Name

    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.
  11. asmenut

    Problem with Entering Output Ranges it gives me a Date!! i.e. 10/23/03

    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...
  12. asmenut

    Problem with Entering Output Ranges it gives me a Date!! i.e. 10/23/03

    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...
  13. asmenut

    Problem with Entering Output Ranges it gives me a Date!! i.e. 10/23/03

    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...
  14. asmenut

    Associate a selected range of cells with a Named Range Object

    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...
  15. asmenut

    Incrementing called worksheet numbers

    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...
See more

Part and Inventory Search

Back
Top