Recent content by dje71183

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?

Thanks for all your help guys. Daniel

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

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

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

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

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.

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.

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?

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

Thats what im trying to say, thank you.

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

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

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

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