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 TugboatEng 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 kris44

  1. kris44

    Clear Cell Contents on VBA

    It's because of the ActiveWorkbook.Close event is before the ThisWorkbook save event, so it's closing without saving Private Sub Button1_Click() Range("C18").ClearContents Range("C21").ClearContents Range("G6").ClearContents Range("G7").ClearContents Range("G8").ClearContents...
  2. kris44

    Running Metrics

    I've modified your spreadsheet and put some formulas in Rows 18 & 19 (Also played around with some of your Defect Numbers) You can see the formulas to use are INDIRECT & ADDRESS, hopefully with the examples given you can work out the remaining formulas you...
  3. kris44

    Charpy V-Notch Test - Chinese Steel

    Our steel supplier has given us test results for Q345B. For Impact Test at 0°C the results are 150, 151 and 177 J. I don't have any experience in this area, but to me it seems very high when you consider the Australian Standard requires only 27J Cheers.
  4. kris44

    Configuring Solidworks to be more like Pro/E

    In regards to your second question, another option would be to assign a mouse gesture (provided you are using SW2010 or 2011)
  5. kris44

    Link part dimension to BOM

    Another method is in the Custom Properties of the Part create a Property (e.g. "Length") linked to the dimension you want in the BOM. To link - place the cursor in the "Value/Text Expression" column then double click on the feature and then on the dimension that you want linked. Then in Custom...
  6. kris44

    help with lookup features

    Paste this formula into Cell B3 =INDEX(INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0),1,,,"Output")):INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0)+100,4,,,"Output")),MATCH(B$2,INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0),2,,,"Output")):INDIRECT(ADDRESS(MATCH($A3,Output!$A:$A,0)+100,2,,,"Output")),0),4)
  7. kris44

    help with lookup features

    First let me say the best method is using "Helper" or "Calculation" columns as iken suggests, but if for some reason you want to use just one formula without adding any columns here goes If you paste the following formula into cell B2 of Loads & then copy across & down you will match what you...
  8. kris44

    To create or not to create threads

    For bolts best to have one only Cut-Revolve which indicates the length of thread.
  9. kris44

    Controlling File Distribution and Copying

    D23, The video uses a method I used before (i.e. use the VeryHidden function). This can still be overcome by someone disabling macros in your workbook, then running a simple macro in another workbook which turns all sheets to Visible. Another possibilty is User Defined Fuctions - these don't...
  10. kris44

    Controlling File Distribution and Copying

    It depends on how secure you want it to be & also how much do the people you send it to know about VBA. Various options include: 1 - When file opens look on the network for a particular file (that way if you're not on the network it will close the file) 2 - In VBA look at Application - there...
  11. kris44

    Used & Unused features

    Another option is Right-click on the feature in the Feature Tree & select "Configure feature"
  12. kris44

    Head drop through Screen

    Our application has a screen inclined at an angle to the stream in a tank (open channel flow). The screen has horizontal & vertical bars as shown. The screen is inclined to the flow by some angle ? which I can determine for each application I'm struggling to find any equation that would fit our...
  13. kris44

    Performance Suggestions

    I used the following methods as required; 1. Use display states instead of Detail & Cropped Views where possible 2. Use Shaded without Edges 3. Hide all views except the one you're working on or only load sheets as you need them 4. Use derived configurations to remove complexity
  14. kris44

    Macro to change Display Style of Drawing View

    Thank you - star for you
  15. kris44

    Macro to change Display Style of Drawing View

    Does anyone have a Macro which will change all drawing views to a particualr Display Style (e.g. HLR, Shaded)? We like to show our assembly drawings in shaded but it makes it very slow to work with them.
See more

Part and Inventory Search

Back
Top