J'aimerais créer une macro me permettant de traiter ce fichier et de le mettre au format .csv sous la forme suivanteFri Jul 2 11:09:11 2010
- Page: 1
S:SAVINESSV5_001:ne1696MS 3.0 Remote Inventory
Board User Label :r01sr1/board#01
Board Location :
Board Type : ESC
ALCATEL Company : ASHB
CLEI Code : WMUCA2KBAA
Unit Part Number : 3AL86661ACAA02
Software Part Number: 3AL95155AAAA02
Serial Number : YP1002085E5
Unit Type : ESC
Factory Identifier : YP
Date Identifier : 00 - Date of final test
Date : 10/02/24
Operator Data : --------------------------------
------------------------------------------------------------------------------
Board User Label :r01sr1/board#03
Board Location :
Board Type : OMDX8100_M_L1_XS_NOSPV
ALCATEL Company : ASHB
CLEI Code : WMD5H0KCAA
Unit Part Number : 3AL86615AAAF01
Software Part Number: --------------
Serial Number : YP1008071D9
Unit Type : OMDX8100
Factory Identifier : YP
Date Identifier : 00 - Date of final test
Date : 10/02/28
Operator Data : --------------------------------
------------------------------------------------------------------------------
/r01sr1/board#01;S:SAVINESSV5_001;;ESC;3AL86661AC;AA02;YP1002085E5;Fri Jul 2 11:09:11 2010
/r01sr1/board#03;S:SAVINESSV5_001;;OMDX8100_M_L1_XS_NOSPV;3AL86615AA;AF01;YP1008071D9;Fri Jul 2 11:09:11 2010
Et en mode pas à pas sa correspond à la ligneErreur d'exécution '13':
Incompatibilité de type
Tblo(7) = CDate(Right(LaDate, 2) & "/" & Mid(LaDate, 4, 2) & "/" & Left(LaDate, 2))
ElseIf Trim(Ligne) Like "Date*" Then
Tblo(7) = Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":") - 1))
[A65000].End(xlUp)(2) = Join(Tblo, ";")
End If
Est-il possible de parer ce genre de défaut ?USER LABEL : MONTIEMED3_0001/r01sr1/board#23
LOCATION NAME :
ELEMENT IDENTIFICATION
ALCATEL company : ASHB
Unit type : SPVM+OW
Unit part number : 3AL86606ABAG02
Software part number : SNOSSA2.0
CLEI code : WM2C1Y7KAA
MANUFACTURING INFORMATION
Manufacturing plant : YP
Serial number : YP100404D1F
Date (00) : 10//2/2/
OPERATOR INVENTORY DATA
----------------------------------------------
ElseIf Trim(Ligne) Like "Date*" Then
Tblo(7) = Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":") - 1))
[A65000].End(xlUp)(2) = Join(Tblo, ";")
End If
ElseIf Trim(Ligne) Like "Date*" Then
LaDate = Trim(Right(Ligne, Len(Ligne) - InStr(1, Ligne, ":") - 1))
If Not IsNumeric(Mid(LaDate, 4, 1)) Then Mid(LaDate, 4, 1) = 0
If Not IsNumeric(Mid(LaDate, 8, 1)) Then Mid(LaDate, 8, 1) = 0
Tblo(7) = CDate(Right(LaDate, 2) & "/" & Mid(LaDate, 4, 2) & "/" & Left(LaDate, 2))
[A65000].End(xlUp)(2) = Join(Tblo, ";")
End If
If Mid(Ligne, InStr(1, Ligne, ":") + 2, 3) = "3AL" Or _
Mid(Ligne, InStr(1, Ligne, ":") + 2, 3) = "3AL" Then