Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski 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 JTBorton

  1. JTBorton

    Back Calc PP MW from melt flow index

    Does anyone know of a method to estimate the average molecular weight or the molecular weight distribution from a measured melt flow rate (or index) of PP? -Joshua Brain storming is when we allow dumb ideas to open our minds to what we might not have thought of before. [M. Passman]
  2. JTBorton

    Edit Add-In and userined function (.xla)

    sbnz, Is this a proprietary add-in, or was it created by a past employee? If you can look into it then it is obviously not password protected. Try this: Make sure no macros are running by pressing the Stop button. In the macro editor, select Tools from the menu, then select References...
  3. JTBorton

    HYSYS PID Tuning

    I'm relatively new to HYSYS dynamics, and am having to brush up a great deal on process control in general. My component mole fractions are 0.02 C1, 0.43 C2, 0.3 C3, 0.125 iC4, 0.125 nC4. The feed enters a fractionation column where C2 is the LK. I am using a feed valve and PI flow controller...
  4. JTBorton

    convert string to formula

    That's pretty good stuff. I've been working on similar issues. Perhaps you can offer a suggestion for me: I want the user to be able to type an equation which can be evaluated. But the kicker is this: I want the user to have the freedom to add VBA functions in the formula, even user-defined...
  5. JTBorton

    Ion Exchange Capacity

    Thanks for the help. The literature has been a tremendous asset. -JTBorton Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]
  6. JTBorton

    Ion Exchange Capacity

    I am very new to Ion Exchange and am having some difficulty understanding the equivilant capacity measurements. I'm seeing things like this: Total Exchange Capacity, min. Units: meq/mL -N(CH3)3 Form: 1.2 -COOH Form: 1.1 Total Exchange Capacity, min. Units: eq/L FB(Free Base)Form: 1.3 Total...
  7. JTBorton

    OPC Automation through VBA

    This may be a total shot in the dark, but... I'm trying to learn how to work with OPC data access (DA) and historical data access (HDA). I'm coming accross a lot of .dll files for OPC automation. Does anyone know where I can find a breakdown of what these .dll files do? I know that I need to...
  8. JTBorton

    Excel picture in sheet

    Using conditional formatting - that's clever, yet so simple! I never would have thought of that. -JTBorton Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]
  9. JTBorton

    Office Data

    Remember, VBA is not meant to be a secured source language in any way. It's only meant for casual scripting. But, I suppose you could read and write encrypted data to a sequential or random access file that exists in a hidden location. But if someone knows how to get into and read code they...
  10. JTBorton

    Images in to worksheets

    MarkusLAndersson, Your attempt is reasonable. It is not working because, as deceptive as the macro recorder is, .Pictures is actually NOT a subclass contained within the worksheet object. Shapes, however, are. If you set the picture to an object then you can mess with it after you add it, as...
  11. JTBorton

    Record macro in Excel

    What is it you are trying to do? Perhaps we can help, or atleast make fools of ourselves trying. -JTBorton Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]
  12. JTBorton

    multiple lines in a text box

    I thought about that too, but I didn't think a list view would let you type data into the cells. Have you been able to do this yourself? I only have limited experience with them. jrice174, I'm guessing that an embeded excel sheet is going to be the most practical option. You might try...
  13. JTBorton

    multiple lines in a text box

    jrice174 What program and version? Are you trying to add this control to a form, or are you trying to add this to a spreadsheet or other type of environment? If you are working in a customized form then you might embed an excel spreadsheet into the form. You do this by right-clicking on the...
  14. JTBorton

    changeing name variabels

    I'm not entirely sure what you are trying to accomplish, but hopefully this will point you in the right direction. I renamed the text box on the worksheet to a more descriptive name. I suggest you do the same if you have several objects on a form. Sub CheckValue() Dim wksRefSheet As...
  15. JTBorton

    VBA Catia: CATParts in a CATProduct considered as Product Objects

    Sorry about the grammar of that second sentence. That should be a question, "Is this something you are accessing through an Excel add-in, pulling in CATIA data files, or are you trying to reference another program through the Excel environment?" -JTBorton Well, You can try banging your head...

Part and Inventory Search