insea
11-09-2007, 06:03 PM
I everybody!
I have 400 worbooks in the same folder (C:\Test), and i would like to open and compare two cells with the condition of the value in the two different cells are the same. If the value is the same give a OK, if not give me that information with the difference in a new file.
Ex.
Cell1 Cell2 Difference File name
A5=2098 R1=2097 #1 DFL.xls
The second procedure of comparing, is I have 5 cells (B1, B2, B3, B4, B5) with different numbers and i want compare the SUM of this 5 cells with another one (C1).
If it is possible do the verification of values in the same procedure better.
Cell1 Cell2 Cell3 Cell4 Cell5 Cell6 Difference File Name
B1=2 B2=4 B3=6 B4=7 B5=8 C1=27 #0 DFL.XLS
The problem is that i have 400 files and i would like to open, Compare and close automatically.
thanks for your help
Insea
I have 400 worbooks in the same folder (C:\Test), and i would like to open and compare two cells with the condition of the value in the two different cells are the same. If the value is the same give a OK, if not give me that information with the difference in a new file.
Ex.
Cell1 Cell2 Difference File name
A5=2098 R1=2097 #1 DFL.xls
The second procedure of comparing, is I have 5 cells (B1, B2, B3, B4, B5) with different numbers and i want compare the SUM of this 5 cells with another one (C1).
If it is possible do the verification of values in the same procedure better.
Cell1 Cell2 Cell3 Cell4 Cell5 Cell6 Difference File Name
B1=2 B2=4 B3=6 B4=7 B5=8 C1=27 #0 DFL.XLS
The problem is that i have 400 files and i would like to open, Compare and close automatically.
thanks for your help
Insea