SHOW:
|
|
- or go back to the newest paste.
1 | - | Prd Esterna |
1 | + | 'Prd Interna |
2 | ||
3 | - | Dim STR_RIGA(1000, 11) As String |
3 | + | Sub PROG_MAC_S4() |
4 | - | 'Dim codfnl(2000, 2) As String |
4 | + | |
5 | - | Dim COD_WRITE(2000, 2) As String |
5 | + | VPRSS = 0 |
6 | str_no_repet = "" | |
7 | - | Sub EXTERNAL_PROD() |
7 | + | |
8 | For CFL = 1 To NM_DT | |
9 | ||
10 | ACT_MOD = "" | |
11 | - | 'STR_DXF = "+" |
11 | + | 'PROGRAMMI EMZ |
12 | - | ' |
12 | + | If INFO_DAT(CFL, 0, 6) = "9999999" Then Call S_9999999(CFL) |
13 | - | ''****************************FAI I DXF CHE NON ESISTONO |
13 | + | |
14 | - | 'For NFGG = 1 To NM_DT |
14 | + | If VAR_ACCORP = True And InStr(1, STR_VR_ACC, INFO_DAT(CFL, 0, 6)) = 0 Then GoTo NO_PROD_INT |
15 | - | ' |
15 | + | If VAR_ACCORP = True And InStr(1, STR_VR_FIBRA, INFO_DAT(CFL, 0, 6)) > 0 Then GoTo NO_PROD_INT |
16 | - | 'If INFO_DAT(NFGG, 0, 23) > 0 And INFO_DAT(NFGG, 0, 28) = 0 And INFO_DAT(NFGG, 0, 11) = "1.8" Then GoTo FAI_DXF |
16 | + | |
17 | - | 'If INFO_DAT(NFGG, 0, 23) > 0 And INFO_DAT(NFGG, 0, 29) = 0 And INFO_DAT(NFGG, 0, 11) = "1.5" Then |
17 | + | '**************************COPRIFESSURA |
18 | - | ' |
18 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014688A" Then Call S_1014688A(CFL) |
19 | - | 'FAI_DXF: |
19 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007069A" Then Call S_1007069A(CFL) |
20 | - | 'If InStr(1, STR_DXF, INFO_DAT(NFGG, 0, 16)) = 0 Then |
20 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10288740" Then Call S_10288740(CFL) |
21 | - | 'Call MODEL_SUB(NFGG, 2) |
21 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026845A" Then Call S_1026845A(CFL) |
22 | - | 'Call READ_DXF(OUTPUT_FOLDER & Right(INFO_DAT(NFGG, 0, 3), 13) & ".DXF", NFGG) |
22 | + | |
23 | - | 'STR_DXF = STR_DXF & "+" & INFO_DAT(NFGG, 0, 16) & "+" |
23 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10328000" Then Call S_10328000(CFL) |
24 | - | 'If INFO_DAT(NFGG, 0, 11) = "1.8" Then FileCopy OUTPUT_FOLDER & Right(INFO_DAT(NFGG, 0, 3), 13) & ".DXF", DXF_ANTE_18 & Right(INFO_DAT(NFGG, 0, 3), 13) & ".DXF" 'DA TESTARE |
24 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10269010" Then Call S_10269010(CFL) |
25 | - | 'If INFO_DAT(NFGG, 0, 11) = "1.5" Then FileCopy OUTPUT_FOLDER & Right(INFO_DAT(NFGG, 0, 3), 13) & ".DXF", DXF_ANTE_15 & Right(INFO_DAT(NFGG, 0, 3), 13) & ".DXF" 'DA TESTARE |
25 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026901A" Then Call S_1026901A(CFL) |
26 | - | ' |
26 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10287960" Then Call S_10287960(CFL) |
27 | - | 'End If |
27 | + | |
28 | - | 'End If |
28 | + | '************************************** RINFORZI/COMPONENTI |
29 | - | 'Next NFGG |
29 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10228760" Then Call S_10228760(CFL) |
30 | - | ''***************************************************** |
30 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006718A" Then Call S_1006718A(CFL) |
31 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006718B" Then Call S_1006718B(CFL) | |
32 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10068200" Then Call S_10068200(CFL) | |
33 | - | Call WRITE_REPORT 'SCRIVO IL REPORT PER LA PRODUZINE ESTERNA |
33 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006820A" Then Call S_1006820A(CFL) |
34 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026716A" Then Call S_1026716A(CFL) | |
35 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026716B" Then Call S_1026716A(CFL) | |
36 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1027588A" Then Call S_1027588A(CFL) | |
37 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1027588C" Then Call S_1027588C(CFL) | |
38 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026699A" Then Call S_1026699A(CFL) | |
39 | - | Sub WRITE_REPORT() 'CREAZIONE REPORT PER PRODUZIONE ESTERNA |
39 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10280840" Then Call S_10280840(CFL) |
40 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10277620" Then Call S_10277620(CFL) | |
41 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1011069A" Then Call S_1011069A(CFL) | |
42 | - | ''Call upld_fnl_ante 'CARICA I CODICI |
42 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020085B" Then Call S_1020085B(CFL) |
43 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020085C" Then Call S_1020085B(CFL) | |
44 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1019999A" Then Call S_1019999A(CFL) | |
45 | - | KJ = 0 |
45 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10067200" Then Call S_10067200(CFL) |
46 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1013300C" Then Call S_1013300C(CFL) | |
47 | - | For RP = 1 To 2 |
47 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1017690A" Then Call S_1017690A(CFL) |
48 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1017690B" Then Call S_1017690B(CFL) | |
49 | - | 'For WW = 1 To 2 |
49 | + | If INFO_DAT(CFL, 0, 6) = "3201155358" Then Call S_3201155358(CFL) |
50 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10163900" Then Call S_10163900(CFL) | |
51 | - | 'Select Case WW |
51 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016517A" Then Call S_1016517A(CFL) |
52 | - | 'Case 1 |
52 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016517B" Then Call S_1016517B(CFL) |
53 | - | 'PRG_AVL = "_1_2_3_" |
53 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016517C" Then Call S_1016517C(CFL) |
54 | - | 'Case 2 |
54 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016517D" Then Call S_1016517C(CFL) |
55 | - | 'PRG_AVL = "_4_5_" |
55 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016517E" Then Call S_1016517E(CFL) |
56 | - | 'End Select |
56 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10174520" Then Call S_10174520(CFL) |
57 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10357360" Then Call S_10357360(CFL) | |
58 | - | PRIMO_PRG = "" |
58 | + | '************************************** |
59 | - | PRG_TOT2 = "" |
59 | + | |
60 | - | For PT = 1 To 5 |
60 | + | |
61 | - | If PRG_NUM(PT) = "" Then Exit For |
61 | + | '**********************ANTE |
62 | - | 'If InStr(PRG_AVL, Right(PRG_NUM(PT), 1)) > 0 Then |
62 | + | NHD = 17 |
63 | - | If PRIMO_PRG = "" Then |
63 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006616A" Then Call S_1006616A(CFL) |
64 | - | PRIMO_PRG = PRG_NUM(PT) |
64 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006619A" Then Call S_1006619A(CFL) |
65 | - | PRG_TOT2 = PRIMO_PRG |
65 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006629E" Then Call S_1006629E(CFL) |
66 | - | Else |
66 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006632B" Then Call S_1006632B(CFL) |
67 | - | PRG_TOT2 = PRIMO_PRG & PRG_NUM(PT) |
67 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006702A" Then Call S_1006702A(CFL) |
68 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006704A" Then Call S_1006704A(CFL) | |
69 | - | 'End If |
69 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006707B" Then Call S_1006707A(CFL) |
70 | - | Next PT |
70 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006711A" Then Call S_1006711A(CFL) |
71 | - | PRG_TOT2 = Replace(PRG_TOT2, "-", "") |
71 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10128290" Then Call S_10128290(CFL) |
72 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10130960" Then Call S_10130960(CFL) | |
73 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015353A" Then Call S_1015353A(CFL) | |
74 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015390A" Then Call S_1015390A(CFL) | |
75 | - | If PRG_TOT2 <> "" Then |
75 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015448C" Then Call S_1015448C(CFL) |
76 | - | For NM = 1 To NN_MAT 'MATERIALE |
76 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015607C" Then Call S_1015607C(CFL) |
77 | - | Erase STR_RIGA |
77 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015627A" Then Call S_1015627A(CFL) |
78 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015591A" Then Call S_1015591A(CFL) | |
79 | - | If RP = 2 Then SUFF = "_4AN" Else SUFF = "_2AN" |
79 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1017011A" Then Call S_1017011A(CFL) |
80 | - | NAMEFL = "FNL-" & PRG_TOT2 & "-" & Replace(STR_MTR(NM), " ", "") & "-OS" & SUFF & ".xlsx" |
80 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1017132A" Then Call S_1017132A(CFL) |
81 | - | NAMEFLPTH = OUTPUT_FOLDER & NAMEFL |
81 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10253920" Then Call S_1025392A(CFL) |
82 | - | 'FINO QUA PER DARE IL TITOLO |
82 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1025682A" Then Call S_1025682A(CFL) |
83 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1025392A" Then Call S_1025392A(CFL) | |
84 | '************************** | |
85 | - | If Len(Dir(NAMEFLPTH)) > 0 Then Kill NAMEFLPTH |
85 | + | |
86 | - | Dim wb As Workbook |
86 | + | '**************************PIASTRONI |
87 | - | Set wb = Workbooks.Add() |
87 | + | NHD = 15 'CAMBIO TESTA PER PIASTRONI E PARAMENTI |
88 | - | wb.SaveAs fileName:=NAMEFLPTH |
88 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1005784C" Then Call S_1005784C(CFL) |
89 | - | Workbooks.Open fileName:=NAMEFLPTH |
89 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1005784D" Then Call S_1005784C(CFL) |
90 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1005784E" Then Call S_1005784E(CFL) | |
91 | - | Cells(1 + 1, 1) = "MATERIALE" |
91 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1005785A" Then Call S_1005785A(CFL) |
92 | - | Cells(1 + 1, 2) = "QTOT" |
92 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1005785B" Then Call S_1005785B(CFL) |
93 | - | Cells(1 + 1, 3) = "COD" |
93 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006615C" Then Call S_1006615C(CFL) |
94 | - | Cells(1 + 1, 4) = "Controllo" |
94 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006615D" Then Call S_1006615E(CFL) |
95 | - | Cells(1 + 1, 5) = "ALS" |
95 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006615E" Then Call S_1006615E(CFL) |
96 | - | Cells(1 + 1, 6) = "AVS" |
96 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006615F" Then Call S_1006615F(CFL) |
97 | - | Cells(1 + 1, 7) = "AVD" |
97 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006615G" Then Call S_1006615G(CFL) |
98 | - | Cells(1 + 1, 8) = "ALD" |
98 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006615H" Then Call S_1006615H(CFL) |
99 | - | Cells(1 + 1, 9) = "COMMESSA" |
99 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006715D" Then Call S_1006715D(CFL) |
100 | - | Cells(1 + 1, 10) = "COD PROG" |
100 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006715E" Then Call S_1006715E(CFL) |
101 | - | Cells(1 + 1, 11) = "Omega" |
101 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006715F" Then Call S_1006715F(CFL) |
102 | - | Cells(1 + 1, 12) = "SEQ" |
102 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902895D" Then Call S_0902895D(CFL) |
103 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902895E" Then Call S_0902895E(CFL) | |
104 | - | 'Cells(1, 11) = "TURNO" |
104 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902895F" Then Call S_0902895F(CFL) |
105 | - | Columns("I:I").NumberFormat = "@" |
105 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902895G" Then Call S_0902895G(CFL) |
106 | - | Columns("J:J").NumberFormat = "@" |
106 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902895J" Then Call S_0902895J(CFL) |
107 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902920C" Then Call S_0902920C(CFL) | |
108 | - | Columns("A:A").ColumnWidth = 12 |
108 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902920D" Then Call S_0902920D(CFL) |
109 | - | Columns("B:B").ColumnWidth = 6.5 |
109 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902920F" Then Call S_0902920F(CFL) |
110 | - | Columns("C:C").ColumnWidth = 18 |
110 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902935C" Then Call S_0902935C(CFL) |
111 | - | Columns("D:D").ColumnWidth = 10 |
111 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "0902935D" Then Call S_0902935D(CFL) |
112 | - | Columns("E:E").ColumnWidth = 8 |
112 | + | '*********************************** |
113 | - | Columns("F:F").ColumnWidth = 8 |
113 | + | '**************************PARAMENTI |
114 | - | Columns("G:G").ColumnWidth = 8 |
114 | + | If INFO_DAT(CFL, 0, 6) = "1007305" Then Call S_1007305(CFL) |
115 | - | Columns("H:H").ColumnWidth = 8 |
115 | + | If INFO_DAT(CFL, 0, 6) = "1007303" Then Call S_1007303(CFL) |
116 | - | Columns("I:I").ColumnWidth = 30 |
116 | + | If INFO_DAT(CFL, 0, 6) = "1007236" Then Call S_1007236(CFL) |
117 | - | Columns("J:J").ColumnWidth = 12 |
117 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1023836A" Then Call S_1023836A(CFL) |
118 | - | Columns("K:K").ColumnWidth = 8 |
118 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1023836B" Then Call S_1023836B(CFL) |
119 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006951B" Then Call S_1006951(CFL) | |
120 | - | Columns("H:H").Select |
120 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006951C" Then Call S_1006951C(CFL) |
121 | - | With Selection |
121 | + | '*********************************** |
122 | - | .HorizontalAlignment = xlCenter |
122 | + | '****************************ENTRANCE -->attesa utensile asola |
123 | - | .VerticalAlignment = xlBottom |
123 | + | NHD = 16 'CAMBIO TESTA PER ENTRANCE |
124 | - | .WrapText = False |
124 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1012500B" Then Call S_1012500(CFL) |
125 | - | .Orientation = 0 |
125 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1012499B" Then Call S_1012499(CFL) 'OK GALLONI |
126 | - | .AddIndent = False |
126 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1011908B" Then Call S_1011908(CFL) |
127 | - | .IndentLevel = 0 |
127 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1011067E" Then Call S_1011067(CFL) 'OK GALLONI |
128 | - | .ShrinkToFit = False |
128 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1011060C" Then Call S_1011060(CFL) 'OK GALLONI |
129 | - | .ReadingOrder = xlContext |
129 | + | |
130 | - | .MergeCells = False |
130 | + | 'If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1037319B" Then Call S_1037319B(CFL) |
131 | - | End With |
131 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1037258B" Then Call S_1037258B(CFL) |
132 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1037258C" Then Call S_1037258C(CFL) | |
133 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1037258D" Then Call S_1037258C(CFL) | |
134 | - | Cells(2, 1).Select |
134 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1037258E" Then Call S_1037258E(CFL) |
135 | - | ActiveCell.Select |
135 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1037258F" Then Call S_1037258F(CFL) |
136 | - | With Selection |
136 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042991A" Then Call S_1042991A(CFL) |
137 | - | .HorizontalAlignment = xlLeft |
137 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042991C" Then Call S_1042991C(CFL) |
138 | - | .VerticalAlignment = xlBottom |
138 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042991C01" Then Call S_1042991C(CFL) |
139 | - | .WrapText = False |
139 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042991D" Then Call S_1042991D(CFL) |
140 | - | .Orientation = 0 |
140 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036865A" Then Call S_1036865A(CFL) |
141 | - | .AddIndent = False |
141 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036865B" Then Call S_1036865B(CFL) |
142 | - | .ShrinkToFit = False |
142 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036865C" Then Call S_1036865C(CFL) |
143 | - | .MergeCells = False |
143 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10483620" Then Call S_10483620(CFL) |
144 | - | End With |
144 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1048362A" Then Call S_1048362A(CFL) |
145 | - | |
145 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10429030" Then Call S_10429030(CFL) |
146 | - | With ActiveSheet.PageSetup |
146 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10429030-MOD" Then Call S_10429030(CFL) |
147 | - | .PrintTitleRows = "" |
147 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042903B" Then Call S_1042903B(CFL) |
148 | - | .PrintTitleColumns = "" |
148 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036714A" Then Call S_1036714A(CFL) |
149 | - | End With |
149 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036714B" Then Call S_1036714A(CFL) |
150 | - | ActiveSheet.PageSetup.PrintArea = "" |
150 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10428730" Then Call S_10428730(CFL) |
151 | - | With ActiveSheet.PageSetup |
151 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042873A" Then Call S_1042873A(CFL) |
152 | - | .LeftHeader = "PROGRAMMA FNL-" & STR_MTR(NM) & "-OS" & SUFF & " FORNITURA ESTERNA" |
152 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1042873A02" Then Call S_1042873A(CFL) |
153 | - | .CenterHeader = "" |
153 | + | |
154 | - | .RightHeader = "Doc 1.SK.U.STM501" |
154 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036629A" Then Call S_1036629A(CFL) |
155 | - | .LeftFooter = "&F" |
155 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036629B" Then Call S_1036629A(CFL) |
156 | - | .CenterFooter = "" |
156 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036629D" Then Call S_1036629D(CFL) |
157 | - | .RightFooter = "Pag. " & "&P" & " \ " & "&N" |
157 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036629E" Then Call S_1036629E(CFL) |
158 | - | .LeftMargin = Application.InchesToPoints(0.33) |
158 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1036629F" Then Call S_1036629F(CFL) |
159 | - | .RightMargin = Application.InchesToPoints(0.33) |
159 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10414310" Then Call S_10414310(CFL) |
160 | - | .TopMargin = Application.InchesToPoints(0.38) |
160 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1041431A" Then Call S_1041431A(CFL) |
161 | - | .BottomMargin = Application.InchesToPoints(0.44) |
161 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1041431B" Then Call S_1041431B(CFL) |
162 | - | .HeaderMargin = Application.InchesToPoints(0.17) |
162 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1041431C" Then Call S_1041431C(CFL) |
163 | - | .FooterMargin = Application.InchesToPoints(0.2) |
163 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1041431D" Then Call S_1041431D(CFL) |
164 | - | .PrintHeadings = False |
164 | + | NHD = 14 |
165 | - | .PrintGridlines = False |
165 | + | '************************************ |
166 | - | .PrintComments = xlPrintNoComments |
166 | + | |
167 | - | .CenterHorizontally = False |
167 | + | |
168 | - | .CenterVertically = False |
168 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10068260" Then Call S_10068260(CFL) |
169 | - | .Orientation = xlLandscape |
169 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006897B" Then Call S_1006897C(CFL) |
170 | - | .Draft = False |
170 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006897C" Then Call S_1006897C(CFL) |
171 | - | .PaperSize = xlPaperA4 |
171 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006897D" Then Call S_1006897D(CFL) |
172 | - | .FirstPageNumber = xlAutomatic |
172 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006897E" Then Call S_1006897E(CFL) |
173 | - | .Order = xlDownThenOver |
173 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006897H" Then Call S_1006897H(CFL) |
174 | - | .BlackAndWhite = False |
174 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007098C" Then Call S_1007098C(CFL) |
175 | - | .Zoom = 80 |
175 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007098D" Then Call S_1007098D(CFL) |
176 | - | End With |
176 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007098E" Then Call S_1007098D(CFL) |
177 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1010304B" Then Call S_1010304B(CFL) | |
178 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1010304C" Then Call S_1010304C(CFL) | |
179 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10130980" Then Call S_10130980(CFL) | |
180 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014657D" Then Call S_1014657D(CFL) | |
181 | - | For NN = 1 To NN_CODE 'COMMESSE ANTE |
181 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014657E" Then Call S_1014657E(CFL) |
182 | - | For I3 = 1 To 1000 'NUMERO DATI GESTITI |
182 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10519690" Then Call S_10519690(CFL) |
183 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10153570" Then Call S_10153570(CFL) | |
184 | - | 'If InStr(1, PRG_AVL, Right(INFO_DAT(I3, 0, 0), 1)) > 0 Then 'NUMERO PROGRAMMA |
184 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1015357A" Then Call S_10153570(CFL) |
185 | - | If INFO_DAT(I3, 0, 25) = STR_MTR(NM) Then |
185 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10155310" Then Call S_10155310(CFL) |
186 | - | If INFO_DAT(I3, 0, 2) = STR_COD(NN) And INFO_DAT(I3, 0, 23) > 0 Then |
186 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10155340" Then Call S_10155340(CFL) |
187 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016400A" Then Call S_1016400A(CFL) | |
188 | - | STR_RIGA(NN, 3) = INFO_DAT(I3, 0, 24) 'CODICE ANTE |
188 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1016520A" Then Call S_1016520A(cfl) 'fondello -- fare dxf |
189 | - | STR_RIGA(NN, 1) = INFO_DAT(I3, 0, 25) 'CODICE MATERIALE |
189 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020374B" Then Call S_1020374B(CFL) |
190 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020374C" Then Call S_1020374B(CFL) | |
191 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020445A" Then Call S_1020445A(CFL) | |
192 | - | STR_RIGA(NN, 3 + INFO_DAT(I3, 0, 23)) = INFO_DAT(I3, 0, 26) & Chr(10) & Chr(13) & INFO_DAT(I3, 0, 13) & "x" & Round(Val(INFO_DAT(I3, 0, 12)), 0) 'CODICE RAGGRUPPAMENTO |
192 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020445B" Then Call S_1020445B(CFL) |
193 | - | STR_RIGA(NN, 2) = Val(INFO_DAT(I3, 0, 4)) 'QUANTITÃ |
193 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020445C" Then Call S_1020445B(CFL) |
194 | - | STR_RIGA(NN, 8) = INFO_DAT(I3, 0, 2) 'COMMESSA |
194 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10202990" Then Call S_10202990(CFL) |
195 | - | STR_RIGA(NN, 9) = INFO_DAT(I3, 0, 32) 'PRG |
195 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020299A" Then Call S_1020299A(CFL) |
196 | - | STR_RIGA(NN, 10) = INFO_DAT(I3, 0, 36) 'SHIFT |
196 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020299B" Then Call S_1020299B(CFL) |
197 | - | STR_RIGA(NN, 11) = INFO_DAT(I3, 0, 6) 'CODICE DISEGNO |
197 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10206680" Then Call S_10206680(CFL) |
198 | - | ''If InStr(1, STR_RIGA(NN, 8), INFO_DAT(I3, 0, 2)) = 0 Then |
198 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020668B" Then Call S_1020668B(CFL) |
199 | - | ''STR_RIGA(NN, 8) = STR_RIGA(NN, 8) & " " & INFO_DAT(I3, 0, 2) & "-" & INFO_DAT(I3, 0, 4) 'COMMESSE + QUANTITÃ |
199 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020668C" Then Call S_1020668B(CFL) |
200 | - | ''STR_RIGA(NN, 2) = Val(STR_RIGA(NN, 2)) + Val(INFO_DAT(I3, 0, 4)) 'QUANTITÃ |
200 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10206400" Then Call S_10206400(CFL) |
201 | - | ''End If |
201 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020640A" Then Call S_10206400(CFL) |
202 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020237A" Then Call S_10202370(CFL) | |
203 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1020092A" Then Call S_1020092A(CFL) | |
204 | - | 'End If |
204 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10229750" Then Call S_10229750(CFL) |
205 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10257410" Then Call S_10257410(CFL) | |
206 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10275400" Then Call S_10275400(CFL) | |
207 | - | Next I3 |
207 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10339350" Then Call S_10339350(CFL) |
208 | - | Next NN |
208 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1033935A" Then Call S_1033935A(CFL) |
209 | - | ''''******************************************************************************* |
209 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10339220" Then Call S_10339220(CFL) |
210 | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1033922A" Then Call S_1033922A(CFL) | |
211 | - | ''For RR2 = 1 To NN_CODE 'SOMMA COMMESSE UGUALI |
211 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10269750" Then Call S_10269750(CFL) |
212 | - | ''For RR3 = 1 + RR2 To NN_CODE |
212 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10284540" Then Call S_10284540(CFL) |
213 | - | '' |
213 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10285220" Then Call S_10285220(CFL) |
214 | - | ''If STR_RIGA(RR2, 4) = STR_RIGA(RR3, 4) And STR_RIGA(RR2, 5) = STR_RIGA(RR3, 5) And STR_RIGA(RR2, 6) = STR_RIGA(RR3, 6) And STR_RIGA(RR2, 7) = STR_RIGA(RR3, 7) Then |
214 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1028522A" Then Call S_10285220(CFL) |
215 | - | '' |
215 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026712A" Then Call S_1026712A(CFL) |
216 | - | ''STR_RIGA(RR2, 2) = Val(STR_RIGA(RR2, 2)) + Val(STR_RIGA(RR3, 2)) |
216 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026633A" Then Call S_1026633A(CFL) |
217 | - | ''STR_RIGA(RR2, 8) = STR_RIGA(RR2, 8) & " " & STR_RIGA(RR3, 8) |
217 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1026633B" Then Call S_1026633A(CFL) |
218 | - | '' |
218 | + | |
219 | - | ''STR_RIGA(RR3, 1) = "" |
219 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10458640" Then Call S_10458640(CFL) |
220 | - | ''STR_RIGA(RR3, 2) = "" |
220 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1045864A" Then Call S_1045864A(CFL) |
221 | - | ''STR_RIGA(RR3, 3) = "" |
221 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1045864B" Then Call S_1045864A(CFL) |
222 | - | ''STR_RIGA(RR3, 4) = "" |
222 | + | |
223 | - | ''STR_RIGA(RR3, 5) = "" |
223 | + | 'If INFO_DAT(cfl, 0, 6) = "1007233" Then Call S_1007233(cfl) |
224 | - | ''STR_RIGA(RR3, 6) = "" |
224 | + | 'If INFO_DAT(cfl, 0, 6) = "1007253" Then Call S_1007253(cfl) |
225 | - | ''STR_RIGA(RR3, 7) = "" |
225 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1007889C" Then Call S_1007889C(cfl) |
226 | - | ''STR_RIGA(RR3, 8) = "" |
226 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1007896B" Then Call S_1007896B(cfl) |
227 | - | ''Else |
227 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1007909G" Then Call S_1007909G(cfl) |
228 | - | ''Exit For |
228 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1007093D" Then Call S_1007093D(cfl) |
229 | - | ''End If |
229 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1006927A" Then Call S_1006927A(cfl) |
230 | - | ''Next RR3 |
230 | + | 'If INFO_DAT(cfl, 0, 6) = "1011763" Then Call S_1011763(cfl) |
231 | - | ''Next RR2 |
231 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1014512C" Then Call S_1014512C(cfl) |
232 | 'If INFO_DAT(cfl, 0, 6) = "1014700" Then Call S_1014700(cfl) | |
233 | - | ''''******************************************************************************* |
233 | + | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1016416D" Then Call S_1016416D(cfl) |
234 | 'If INFO_DAT(cfl, 0, 6) & INFO_DAT(cfl, 0, 9) = "1016428B" Then Call S_1016428B(cfl) | |
235 | - | RR = 1 ' 0 |
235 | + | |
236 | - | ''For SH = 2 To 1 Step -1 |
236 | + | |
237 | - | 'For SQ = 300 To 1 Step -1 |
237 | + | |
238 | - | For SQ = 1 To 300 |
238 | + | '********************************OUTPUT DXF *********************** |
239 | - | For NN1 = 1 To UBound(STR_RIGA) |
239 | + | |
240 | If InStr(1, str_no_repet, INFO_DAT(CFL, 0, 3)) = 0 Then | |
241 | - | ''If Val(STR_RIGA(NN1, 10)) = SH Then |
241 | + | |
242 | - | If Val(STR_RIGA(NN1, 9)) = SQ Then |
242 | + | cd_dxf = "_1006908_1006914_1006930_1007161_1007886_1011060_1011067_1011908_1011069_1012499_1012500_1007909_1016416_1016428_1007253_1020145_1022168_1020979_1020899_1023837_1023240_" |
243 | - | If STR_RIGA(NN1, 3) <> "" Then |
243 | + | cd_dxf = cd_dxf & "_1045862_1045866_1045872_1046016_1014512_1016520_1007896_1078916_1078917_1016517_" |
244 | cd_mag = "_3212155519_" | |
245 | - | RR = RR + 1 |
245 | + | If InStr(1, cd_dxf, INFO_DAT(CFL, 0, 6)) > 0 Or InStr(1, cd_mag, INFO_DAT(CFL, 0, 6)) > 0 Then |
246 | - | Cells(RR + 1, 1) = STR_RIGA(NN1, 1) |
246 | + | str_no_repet = str_no_repet & "-" & INFO_DAT(CFL, 0, 3) & "_" |
247 | - | Cells(RR + 1, 2) = STR_RIGA(NN1, 2) |
247 | + | |
248 | - | Cells(RR + 1, 3) = STR_RIGA(NN1, 3) |
248 | + | |
249 | - | Cells(RR + 1, 4 + 1) = STR_RIGA(NN1, 4) |
249 | + | If INFO_DAT(CFL, 0, 6) = "1006908" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
250 | - | Cells(RR + 1, 5 + 1) = STR_RIGA(NN1, 5) |
250 | + | If INFO_DAT(CFL, 0, 6) = "1006914" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
251 | - | Cells(RR + 1, 6 + 1) = STR_RIGA(NN1, 6) |
251 | + | If INFO_DAT(CFL, 0, 6) = "1006930" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
252 | - | Cells(RR + 1, 7 + 1) = STR_RIGA(NN1, 7) |
252 | + | If INFO_DAT(CFL, 0, 6) = "1007161" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
253 | - | Cells(RR + 1, 8 + 1) = STR_RIGA(NN1, 8) |
253 | + | If INFO_DAT(CFL, 0, 6) = "1007886" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
254 | - | If InStr(1, comm_omg_spc, STR_RIGA(NN1, 8)) > 0 Then |
254 | + | |
255 | - | Cells(RR + 1, 10 + 1) = "SI" |
255 | + | ''If INFO_DAT(CFL, 0, 6) = "1011060" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) 'ENTRANCE |
256 | ''If INFO_DAT(CFL, 0, 6) = "1011067" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) | |
257 | - | Cells(RR + 1, 12) = STR_RIGA(NN1, 9) |
257 | + | ''If INFO_DAT(CFL, 0, 6) = "1011908" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
258 | - | Cells(RR + 1, 9 + 1) = COD_PIEGA(STR_RIGA(NN1, 3), STR_RIGA(NN1, 11)) |
258 | + | ''If INFO_DAT(CFL, 0, 6) = "1012499" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
259 | ''If INFO_DAT(CFL, 0, 6) = "1012500" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) | |
260 | ||
261 | - | 'Cells(RR + 1, 11) = STR_RIGA(NN1, 10) |
261 | + | 'If INFO_DAT(CFL, 0, 6) = "1007909" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
262 | 'If INFO_DAT(CFL, 0, 6) = "1016416" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) | |
263 | - | '''''**************************************************************GENERO IL NUOVO CODICE DI IDENTIFICAZIONE |
263 | + | If INFO_DAT(CFL, 0, 6) = "1007253" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
264 | - | ''''VVV = Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) |
264 | + | |
265 | - | '''' |
265 | + | |
266 | - | '''' |
266 | + | If INFO_DAT(CFL, 0, 6) = "1020145" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
267 | - | ''''If Cells(RR + 1, 4 + 1) = "" Then |
267 | + | If INFO_DAT(CFL, 0, 6) = "1022168" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
268 | - | ''''CC1 = "N" |
268 | + | If INFO_DAT(CFL, 0, 6) = "1020979" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
269 | - | ''''Else |
269 | + | If INFO_DAT(CFL, 0, 6) = "1020899" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
270 | - | ''''CC1 = Right(Cells(RR + 1, 4 + 1), 2) |
270 | + | If INFO_DAT(CFL, 0, 6) = "1023837" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
271 | - | ''''End If |
271 | + | |
272 | - | ''''If Cells(RR + 1, 5 + 1) = "" Then |
272 | + | If INFO_DAT(CFL, 0, 6) = "1016520" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
273 | - | ''''CC2 = "N" |
273 | + | |
274 | - | ''''Else |
274 | + | If INFO_DAT(CFL, 0, 6) = "1045862" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
275 | - | ''''CC2 = Right(Cells(RR + 1, 5 + 1), 2) |
275 | + | If INFO_DAT(CFL, 0, 6) = "1045866" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
276 | - | ''''End If |
276 | + | If INFO_DAT(CFL, 0, 6) = "1045872" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
277 | - | ''''If Cells(RR + 1, 6 + 1) = "" Then |
277 | + | If INFO_DAT(CFL, 0, 6) = "1046016" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
278 | - | ''''CC3 = "N" |
278 | + | If INFO_DAT(CFL, 0, 6) = "1078916" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
279 | - | ''''Else |
279 | + | If INFO_DAT(CFL, 0, 6) = "1078917" And INFO_DAT(CFL, 0, 19) = 0 Then Call MODEL_SUB(CFL, 1) |
280 | - | ''''CC3 = Right(Cells(RR + 1, 6 + 1), 2) |
280 | + | |
281 | - | ''''End If |
281 | + | |
282 | - | ''''If Cells(RR + 1, 7 + 1) = "" Then |
282 | + | |
283 | - | ''''CC4 = "N" |
283 | + | |
284 | - | ''''Else |
284 | + | If InStr(1, str_no_repet, INFO_DAT(CFL, 0, 3)) = 0 Then 'CHECK SU MODULO O DXF MANCANTE |
285 | - | ''''CC4 = Right(Cells(RR + 1, 7 + 1), 2) |
285 | + | If ACT_MOD = "" Then MsgBox ("MODULO " & INFO_DAT(CFL, 0, 6) & " MANCANTE") |
286 | - | ''''End If |
286 | + | |
287 | - | ''''CCC = CC1 & CC2 & CC3 & CC4 |
287 | + | |
288 | - | '''' |
288 | + | ACT_MOD = "" |
289 | - | '''' |
289 | + | NO_PROD_INT: |
290 | - | ''''NUM_CC = quanteVolte(CCC, "N") |
290 | + | |
291 | - | ''''Select Case NUM_CC |
291 | + | Next CFL |
292 | - | ''''Case Is >= 2 |
292 | + | |
293 | - | ''''If Cells(RR + 1, 4 + 1) = "" Then |
293 | + | |
294 | - | ''''CC1 = "N" |
294 | + | VPRSS = 1 |
295 | - | ''''Else |
295 | + | For CFL = 1 To NM_DT |
296 | - | ''''CC1 = Right(Cells(RR + 1, 4 + 1), 3) |
296 | + | |
297 | - | ''''End If |
297 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014688A" Then Call V_1014688A(CFL) |
298 | - | ''''If Cells(RR + 1, 5 + 1) = "" Then |
298 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016428C" Then Call V_1016428C(CFL) |
299 | - | ''''CC2 = "N" |
299 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014512C" Then Call V_1014512C(CFL) |
300 | - | ''''Else |
300 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10339490" Then Call V_10339490(CFL) |
301 | - | ''''CC2 = Right(Cells(RR + 1, 5 + 1), 3) |
301 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016416E" Then Call V_1016416E(CFL) |
302 | - | ''''End If |
302 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "10339850" Then Call V_1033985B(CFL) |
303 | - | ''''If Cells(RR + 1, 6 + 1) = "" Then |
303 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1033985B" Then Call V_1033985B(CFL) |
304 | - | ''''CC3 = "N" |
304 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006951B" Then Call V_1006951(CFL) |
305 | - | ''''Else |
305 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006951C" Then Call V_1006951C(CFL) |
306 | - | ''''CC3 = Right(Cells(RR + 1, 6 + 1), 3) |
306 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1023836A" Then Call V_1023836A(CFL) |
307 | - | ''''End If |
307 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007889B" Then Call V_1007889B(CFL) |
308 | - | ''''If Cells(RR + 1, 7 + 1) = "" Then |
308 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007889E" Then Call V_1007889E(CFL) |
309 | - | ''''CC4 = "N" |
309 | + | |
310 | - | ''''Else |
310 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007233" Then Call V_1007233(CFL) |
311 | - | ''''CC4 = Right(Cells(RR + 1, 7 + 1), 3) |
311 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007236" Then Call V_1007236(CFL) |
312 | - | ''''End If |
312 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007253" Then Call V_1007253(CFL) |
313 | - | ''''CCC = CC1 & CC2 & CC3 & CC4 |
313 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007303" Then Call V_1007303(CFL) |
314 | - | ''''Case Is < 2 |
314 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007305" Then Call V_1007305(CFL) |
315 | - | '''' |
315 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007896B" Then Call V_1007896B(CFL) |
316 | - | ''''CCC = CCC |
316 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007896C" Then Call V_1007896C(CFL) |
317 | - | ''''End Select |
317 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1011763" Then Call V_1011763(CFL) |
318 | - | '''' |
318 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007909H" Then Call V_1007909H(CFL) |
319 | - | '''''************************************CODICI DOPPI |
319 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1006927A" Then Call V_1006927A(CFL) |
320 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "722514926051830524724342" Then CCC = "14512442B" |
320 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007093D" Then Call V_1007093D(CFL) |
321 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "724715830357935190722817" Then CCC = "15579017B" |
321 | + | |
322 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "714655945755945756714657" Then CCC = "55555657B" |
322 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016416F" Then Call V_1016416F(CFL) |
323 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "1022660102265910241651022429" Then CCC = "60596529B" |
323 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1016428D" Then Call V_1016428D(CFL) |
324 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "1021337102133510213361021338" Then CCC = "37353638B" |
324 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007909J" Then Call V_1007909J(CFL) |
325 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "830531830533" Then CCC = "NN531533B" |
325 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007909M" Then Call V_1007909M(CFL) |
326 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "1022402102240110224001022403" Then CCC = "02010003B" |
326 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007909M-MOD" Then Call V_1007909J(CFL) |
327 | - | ''''If Cells(RR + 1, 4 + 1) & Cells(RR + 1, 5 + 1) & Cells(RR + 1, 6 + 1) & Cells(RR + 1, 7 + 1) = "1021337102553610213361021338" Then CCC = "37363638B" |
327 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007909N" Then Call V_1007909M(CFL) |
328 | - | '''''************************************************ |
328 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007889F" Then Call V_1007889F(CFL) |
329 | - | ''''Cells(RR + 1, 9 + 1) = CCC |
329 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007889G" Then Call V_1007889H(CFL) |
330 | - | '''' |
330 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1007889H" Then Call V_1007889H(CFL) |
331 | - | '''' |
331 | + | |
332 | - | '''' |
332 | + | |
333 | - | ''''ATT = 0 |
333 | + | |
334 | - | ''''For G1 = 1 To Val(codfnl(0, 0)) |
334 | + | 'If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014700" Then Call V_1014700(CFL) |
335 | - | ''''If CCC = codfnl(G1, 1) Then |
335 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014700C" Then MsgBox ("chiedere dxf a Galloni cod. " & INFO_DAT(CFL, 0, 6)) |
336 | - | ''''If VVV = codfnl(G1, 2) Then |
336 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1023837A" Then MsgBox ("chiedere dxf a Galloni cod. " & INFO_DAT(CFL, 0, 6)) 'Call S_1023837A(CFL) |
337 | - | ''''ATT = 1 |
337 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1014660A" Then MsgBox ("chiedere dxf a Galloni cod. " & INFO_DAT(CFL, 0, 6)) |
338 | - | ''''Else |
338 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1023240B" Then MsgBox ("chiedere dxf a Galloni cod. " & INFO_DAT(CFL, 0, 6)) |
339 | - | ''''MsgBox ("ATTENZIONE CODICE PROGRAMMA " & CCC & " DOPPIO, NOMINARLO DIVERSAMENTE") |
339 | + | If INFO_DAT(CFL, 0, 6) & INFO_DAT(CFL, 0, 9) = "1023240C" Then MsgBox ("chiedere dxf a Galloni cod. " & INFO_DAT(CFL, 0, 6)) |
340 | - | ''''End If |
340 | + | |
341 | - | ''''End If |
341 | + | Next CFL |
342 | - | ''''Next G1 |
342 | + | |
343 | - | '''' |
343 | + | |
344 | - | ''''If ATT = 0 Then |
344 | + | |
345 | - | ''''KJ = KJ + 1 |
345 | + | |
346 | - | ''''COD_WRITE(KJ, 1) = CCC |
346 | + |