Re : Importer des données d'un fichier .txt
Bonjour Larson,
Merci de te pencher sur mon problème.
J'ai mis en pièce jointe un exemple de mes écritures en vb et ci dessous un exemple du fichier text à traiter avec la macro.
"02/01/2009 15:50:46",#1899-12-30 07:25:00#,"13172","8",#1899-12-30 00:30:00#,#1899-12-30 00:20:00#,#1899-12-30 01:10:00#,"74%","00:00","","00:05","com1","00:00","","00:10","com2","00:00","","00:05","com3","00:10","com4","00:00","","00:15","com5","00:05","com6","00:00","","00:10","com7","com8","00:00","com9","com10","00:10",""
"30/12/2008",#1899-12-30 07:25:00#,"12629","10",#1899-12-30 00:30:00#,#1899-12-30 00:20:00#,#1899-12-30 01:25:00#,"70,94%","00:10","com1","00:00","","00:05","com2","00:00","","00:05","com3","00:20","com4","00:05","com5","00:05","com6","00:10","com7","00:00","","00:00","","00:20","com8","com9","00:05","com10","","00:00",""
"05/01/2009 08:51:17",#1899-12-30 04:00:00#,"5460","6",#1899-12-30#,#1899-12-30 00:15:00#,#1899-12-30 00:30:00#,"56,87%","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","com1","00:05","com2","00:00","","00:15","com3","00:00","","00:00","","00:00","","com4","00:10","com5","","00:00",""
"03/01/2009 08:55:20",#1899-12-30 06:50:00#,"12854","9",#1899-12-30 00:30:00#,#1899-12-30 00:20:00#,#1899-12-30 00:40:00#,"78,37%","00:00","","00:00","","00:00","","00:00","com1","00:00","","00:25","com2","00:05","com3","00:00","","00:00","","00:00","","00:00","","00:00","","com4","00:10","com5","","00:00",""
"02/01/2009 14:44:59",#1899-12-30 03:30:00#,"16970","3",#1899-12-30#,#1899-12-30#,#1899-12-30#,"84,17%","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","00:00","","","00:00","","","00:00",""
Je n'arrive pas à ajouter le taux dans la colonne 2.
Merci pour ton aide.