Sub Newcorrectionfiletxt() Nombrecor = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("E5").Value Annee = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("E4").Value Dim i As Integer i = 8 While i <= Nombrecor A = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("I" & i & "").Value B = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("J" & i & "").Value Nom = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("K" & i & "").Text Tip = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("L" & i & "").Text Localisation1 = "H:\Materiaux\Projets\INM\3-Production\Electrique\Automatisation\Stage - 11.04.11 - 18.06.11\Fichiers de correction" & Annee & "" & Nom & ".txt" Open Localisation1 For Output As #1 Print #1, "Moi MET/CAL Procedure" & _ Chr(13) + Chr(10) & "=============================================================================" & _ Chr(13) + Chr(10) & "INSTRUMENT: " & Nom & "" & _ Chr(13) + Chr(10) & "DATE:" & _ Chr(13) + Chr(10) & "REVISION:" & _ Chr(13) + Chr(10) & "ADJUSTMENT THRESHOLD: 70%" & _ Chr(13) + Chr(10) & "NUMBER OF TESTS: 1" & _ Chr(13) + Chr(10) & "NUMBER OF LINES: 20" & _ Chr(13) + Chr(10) & "=============================================================================" & _ Chr(13) + Chr(10) & " STEP FSC RANGE NOMINAL TOLERANCE MOD1 MOD2 3 4 CON" & _ Chr(13) + Chr(10) & " 1.001 ASK- W" & _ Chr(13) + Chr(10) & " 1.002 ASK+ K" & _ Chr(13) + Chr(10) & " 1.003 ASK+ C" & _ Chr(13) + Chr(10) & " 1.004 MATH MEM1= (M[1] + M[1] * " & A & " " & B & ")" & _ Chr(13) + Chr(10) & " 1.005 DOS correct [S1] 5520 insert ""Volts"" [M1]V" & _ Chr(13) + Chr(10) & " 1.006 MATH M[2]=ACCV(""Fluke 5520A"",""Volts"",M[1])" & _ Chr(13) + Chr(10) & " 1.007 MATH MEM=MEM1" & _ Chr(13) + Chr(10) & " 1.008 ACC " & Tip & " M2U" Close #1 i = i + 1 Wend End Sub
Dim maCellule As Range For Each maCellule In ActiveSheet.Range("D1:D10") Debug.Print "Cellule " & maCellule.Address & ", contient " & maCellule.Value Debug.Print "Cellule " & maCellule.Offset(0,2).Address & ", contient " & maCellule.Offset(0,2).Value Next
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub Newcorrectionfiletxt() Nombrecor = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("E5").Value Annee = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("E4").Value Dim i As Integer i = 8 While i <= Nombrecor A = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("I" & i & "").Value B = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("J" & i & "").Value Nom = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("K" & i & "").Text Tip = Application.Workbooks("F.AMS.MET.ELEC.25-v6_5520_MET-ELM-001_v0.2.xls").Worksheets("Incert&Correction").Range("L" & i & "").Text Localisation1 = "H:\Materiaux\Projets\INM\3-Production\Electrique\Automatisation\Stage - 11.04.11 - 18.06.11\Fichiers de correction" & Annee & "" & Nom & ".txt" Open Localisation1 For Output As #1 Print #1, "Moi MET/CAL Procedure" & _ Chr(13) + Chr(10) & "=============================================================================" & _ Chr(13) + Chr(10) & "INSTRUMENT: " & Nom & "" & _ Chr(13) + Chr(10) & "DATE:" & _ Chr(13) + Chr(10) & "REVISION:" & _ Chr(13) + Chr(10) & "ADJUSTMENT THRESHOLD: 70%" & _ Chr(13) + Chr(10) & "NUMBER OF TESTS: 1" & _ Chr(13) + Chr(10) & "NUMBER OF LINES: 20" & _ Chr(13) + Chr(10) & "=============================================================================" & _ Chr(13) + Chr(10) & " STEP FSC RANGE NOMINAL TOLERANCE MOD1 MOD2 3 4 CON" & _ Chr(13) + Chr(10) & " 1.001 ASK- W" & _ Chr(13) + Chr(10) & " 1.002 ASK+ K" & _ Chr(13) + Chr(10) & " 1.003 ASK+ C" & _ Chr(13) + Chr(10) & " 1.004 MATH MEM1= (M[1] + M[1] * " & A & " " & B & ")" & _ Chr(13) + Chr(10) & " 1.005 DOS correct [S1] 5520 insert ""Volts"" [M1]V" & _ Chr(13) + Chr(10) & " 1.006 MATH M[2]=ACCV(""Fluke 5520A"",""Volts"",M[1])" & _ Chr(13) + Chr(10) & " 1.007 MATH MEM=MEM1" & _ Chr(13) + Chr(10) & " 1.008 ACC " & Tip & " M2U" Close #1 i = i + 1 Wend End Sub
^ Open Localisation1 For Append As #1 Print #1, "Moi MET/CAL Procedure" Print #1, "=============================================================================" Print #1, "INSTRUMENT: " & Titre & "-" & Dat & "" Print #1, "DATE:" Print #1, "REVISION:" Print #1, "ADJUSTMENT THRESHOLD: 70%" Print #1, "NUMBER OF TESTS: 1" Print #1, "NUMBER OF LINES: 20" Print #1, "=============================================================================" Print #1, " STEP FSC RANGE NOMINAL TOLERANCE MOD1 MOD2 3 4 CON" Print #1, " 1.001 ASK- R P A W" Print #1, " 1.002 ASK+ K" Print #1, " 1.003 HEAD Information test" Print #1, " 1.004 DISP Bonjour, vous avez lancé cette procédure d'étalonnage :" Print #1, " 1.005 DISP Vous allez étalonner : " & Titre & "" Print #1, " 1.006 DISP Attention, le test va débuter..."