jphermans
01-17-2005, 06:25 AM
I've got an logfile with a lot of information that looks like this:
17.01.2005 08:59:07
Wp ID: 0774503
Left Mode: P2.X_Alu OK
Bolt 01 Program: P2.X_Alu Bolt T: 140.8 Bolt A: 66 OK Errors:
Bolt 02 Program: P2.X_Alu Bolt T: 142.0 Bolt A: 73 OK Errors:
Bolt 03 Program: P2.X_Alu Bolt T: 143.5 Bolt A: 70 OK Errors:
Bolt 04 Program: P2.X_Alu Bolt T: 143.6 Bolt A: 68 OK Errors:
Bolt 05 Program: P2.X_Alu Bolt T: 141.1 Bolt A: 69 OK Errors:
17.01.2005 08:59:33
Wp ID: 0774503
Left Mode: P2.X_Alu OK
Bolt 06 Program: P2.X_Alu Bolt T: 140.4 Bolt A: 64 OK Errors:
Bolt 07 Program: P2.X_Alu Bolt T: 140.1 Bolt A: 68 OK Errors:
Bolt 08 Program: P2.X_Alu Bolt T: 142.7 Bolt A: 60 OK Errors:
Bolt 09 Program: P2.X_Alu Bolt T: 140.3 Bolt A: 63 OK Errors:
Bolt 10 Program: P2.X_Alu Bolt T: 142.3 Bolt A: 66 OK Errors:
Now i want every thing in an excel sheet in colums like this:
Bolt,program, Bolt T: , Bolt A: ,...
But the logfile is 10mb and is to much work to do it manually.
Anybody an idea how to solve it with vba ?
17.01.2005 08:59:07
Wp ID: 0774503
Left Mode: P2.X_Alu OK
Bolt 01 Program: P2.X_Alu Bolt T: 140.8 Bolt A: 66 OK Errors:
Bolt 02 Program: P2.X_Alu Bolt T: 142.0 Bolt A: 73 OK Errors:
Bolt 03 Program: P2.X_Alu Bolt T: 143.5 Bolt A: 70 OK Errors:
Bolt 04 Program: P2.X_Alu Bolt T: 143.6 Bolt A: 68 OK Errors:
Bolt 05 Program: P2.X_Alu Bolt T: 141.1 Bolt A: 69 OK Errors:
17.01.2005 08:59:33
Wp ID: 0774503
Left Mode: P2.X_Alu OK
Bolt 06 Program: P2.X_Alu Bolt T: 140.4 Bolt A: 64 OK Errors:
Bolt 07 Program: P2.X_Alu Bolt T: 140.1 Bolt A: 68 OK Errors:
Bolt 08 Program: P2.X_Alu Bolt T: 142.7 Bolt A: 60 OK Errors:
Bolt 09 Program: P2.X_Alu Bolt T: 140.3 Bolt A: 63 OK Errors:
Bolt 10 Program: P2.X_Alu Bolt T: 142.3 Bolt A: 66 OK Errors:
Now i want every thing in an excel sheet in colums like this:
Bolt,program, Bolt T: , Bolt A: ,...
But the logfile is 10mb and is to much work to do it manually.
Anybody an idea how to solve it with vba ?