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