Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Search results for query: *

  1. dje71183

    Comparing Excel files

    Hello all. I receive once a month a updated pricing for about 25,000 parts. Is there a way to compare the each months and see only the parts that have change?
  2. dje71183

    SW cant Convert stp and igs files.

    Thanks for all your help guys. Daniel
  3. dje71183

    SW cant Convert stp and igs files.

    Im sorry, but i cant post the file. John Deere wouldnt be happy. LOL
  4. dje71183

    SW cant Convert stp and igs files.

    That didnt help much. It seemed to start out faster, but it still didnt open.
  5. dje71183

    SW cant Convert stp and igs files.

    I turned HT off but I still cant open the files.
  6. dje71183

    SW cant Convert stp and igs files.

    VM is 1536MB int 3000MB max Does Hyper-threading hurt my performance?
  7. dje71183

    SW cant Convert stp and igs files.

    Im sorry, what is VM? I looks only to be large files im haing the problem with. I can open a 150MB SW file with no problem.
  8. dje71183

    SW cant Convert stp and igs files.

    My work is to cheap to buy the service to update SW. All RAM is being recongnised. Each time when I try to open a large file, it takes for ever to open or the computer freezes.
  9. dje71183

    SW cant Convert stp and igs files.

    Computer: Win Xp Pro P4 3.2Ghz 2 Gb ram Nvidia Quadro FX 1400 Drivers 6.14.10.7184 Software: Solid Works 2005 SP 0.0 Problem: Can not open/covert stp and igs files that are between 20mb and 300 mb. Does hyper threading help? Any suggestions?
  10. dje71183

    Sort

    I found my problem. Worksheets("Information").Range("N69:R1500").Sort _ Key1:=Worksheets("Information").Range("N69"), _ Order1:=xlDescending, _ Key2:=Worksheets("Information").Range("R1") thanks.
  11. dje71183

    Sort

    Thats what im trying to say, thank you.
  12. dje71183

    Sort

    I want my results to start on cell N69. Doestn matter Ascending or Descending..
  13. dje71183

    Sort

    I am trying to sort in excel using VBA. My code is Worksheets("Information").Range("N69:R1500").Sort _ Key1:=Worksheets("Information").Range("R1500"), _ Key2:=Worksheets("Information").Range("O69") Problem is that its starts at the N,1500 and moves up to 1499, 1498, and so on. I...
  14. dje71183

    Procedure too large

    I changed the code to Select Case Sub engine_cost() Select Case Range("Reference!A2").Value Case 1, 20, 41, 59 Range("Information!D16") = Range("Reference!E3") Case Is > 1, Is < 59 Range("Information!D16") = Range("'Engine...
  15. dje71183

    Procedure too large

    I am now calling all my procedures. Thanks for all the help. Daniel
  16. dje71183

    Procedure too large

    I am using VBA in Excel 2003. I have a very long procedure and I tried turning it into sub procedures, but when I did that, it only performs my first procedure and none of the others. This is about 1/9 of the procedure. I have 9 "if". Sub engine_cost() 'Sets engine prices If...
  17. dje71183

    Updating list

    This is my first time doing something like this so please bear with me. I am trying to set up a program using VB in Excel. I have a master list of parts and prices. Sub lists made up of parts and prices from the master. Both the master list and sub lists on same worksheet. I want to be...

Part and Inventory Search