Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================On Error GoTo 2
- Workbooks.Open Filename:=cudir & "\" & "01_янв" & "\" & "DSDI905_0116.xls"
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("A29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- 2:
- On Error GoTo 3
- Workbooks.Open Filename:=cudir & "\" & "02_фев" & "\" & "DSDI905_0216.xls"
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("D29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0216.xls").Close
- '==================================================
- 3:
- On Error GoTo 4
- Workbooks.Open Filename:=cudir & "\" & "03_мар" & "\" & "DSDI905_0316.xls"
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("G29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0316.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0316.xls").Close
- '==================================================
- 4:
- On Error GoTo 5
- Workbooks.Open Filename:=cudir & "\" & "04_апр" & "\" & "DSDI905_0416.xls"
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("J29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0416.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0416.xls").Close
- '==================================================
- 5:
- On Error GoTo 6
- Workbooks.Open Filename:=cudir & "\" & "05_май" & "\" & "DSDI905_0516.xls"
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("M29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0516.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0516.xls").Close
- '==================================================
- 6:
- On Error GoTo 7
- Workbooks.Open Filename:=cudir & "\" & "06_июнь" & "\" & "DSDI905_0616.xls"
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("P29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0616.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0616.xls").Close
- '==================================================
- 7:
- On Error GoTo a8
- Workbooks.Open Filename:=cudir & "\" & "07_июль" & "\" & "DSDI905_0716.xls"
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("S29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0716.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0716.xls").Close
- '==================================================
- a8:
- On Error GoTo a9
- Workbooks.Open Filename:=cudir & "\" & "08_авг" & "\" & "DSDI905_0816.xls"
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("V29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0816.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0816.xls").Close
- '==================================================
- a9:
- On Error GoTo a10
- Workbooks.Open Filename:=cudir & "\" & "09_сент" & "\" & "DSDI905_0916.xls"
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("Y29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_0916.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0916.xls").Close
- '==================================================
- a10:
- On Error GoTo a11
- Workbooks.Open Filename:=cudir & "\" & "10_окт" & "\" & "DSDI905_1016.xls"
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AB29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1016.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1016.xls").Close
- '==================================================
- a11:
- On Error GoTo a12
- Workbooks.Open Filename:=cudir & "\" & "11_ноя" & "\" & "DSDI905_1116.xls"
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AE29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1116.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_0116.xls").Close
- '==================================================
- a12:
- On Error GoTo a13
- Workbooks.Open Filename:=cudir & "\" & "12_дек" & "\" & "DSDI905_1216.xls"
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист2").Select
- formula2sh
- Range("G6:H32").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH2").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- Sheets("Лист3").Select
- formula3sh
- Range("G6:H21").Copy
- wb.Activate
- Sheets("buffer").Select
- Range("AH29").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Windows("DSDI905_1216.xls").Activate
- ActiveWorkbook.Save
- Windows("DSDI905_1216.xls").Close
- '==================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement