excel ftp
Tarih
31/03/2012 08:25
Konu Sahibi
accessman
Yorumlar
1
Okunma
1331
Konuyu Oyla:
  • Derecelendirme: 0/5 - 0 oy
  • 5
  • 4
  • 3
  • 2
  • 1

Derecelendirme: 0/5 - 0 oy



accessman

Kullanici Avatari
Onursal
2.367
31/10/2008
425
Denizli
Ofis 2003
20/09/2016,00:20
bu Excel için upload kodu

Visual Basic Code
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
Sub Filter() 
 Dim name As Object 
 Application.ScreenUpdating = False 
 Application.DisplayAlerts = False 
 ActiveSheet.Unprotect Password:="letmein" 
 MYCOUNTER = 100 
 
 Do Until MYCOUNTER > 254 ' START LOOP
 Selection.AutoFilter Field:=7, Criteria1:=MYCOUNTER + 1 
 MYCOUNTER = MYCOUNTER + 1 
 Range("I1").Value = MYCOUNTER 
 Selection.AutoFilter Field:=5, Criteria1:="S3R" 
 Selection.AutoFilter Field:=6, Criteria1:="F" 
 Range("A1").Select 
 Range("A" & Rows.Count).End(xlUp).Select 
 If ActiveCell.Value <> "Name" Then 
 Set name = Range("H" & Rows.Count).End(xlUp) 
 Range("J1").Value = name 
 Columns("A:A").Select 
 Range("A:H").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:= _ 
 xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ 
 DataOption1:=xlSortNormal 
 Workbooks.Add Template:= _ 
 "C:\Documents and Settings\kfurbush\Application Data\Microsoft\Templates\FT Bi Test.xlt" 
 Sheets("Summary Sheet").Select 
 ActiveSheet.Unprotect Password:="letmein" 
 Windows("TemplateCreation.xls").Activate 
 Range("A2:D" & Range("A" & Rows.Count).End(xlUp).Row).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("FT Bi Test1").Activate 
 Range("A11").Select 
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ 
 :=False, Transpose:=False 
 Windows("TemplateCreation.xls").Activate 
 Range("H" & Rows.Count).End(xlUp).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("FT Bi Test1").Activate 
 Range("A7:B7").Select 
 ActiveSheet.Paste 
 'Add PG and BatchID
 Windows("TemplateCreation.xls").Activate 
 Range("E" & Rows.Count).End(xlUp).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("FT Bi Test1").Activate 
 Sheets("Upload").Visible = True 
 Sheets("Exception Report").Visible = True 
 Sheets("Exception Report").Select 
 Range("C4").Select 
 ActiveSheet.Paste 
 Range("C4").Select 
 Application.CutCopyMode = False 
 Selection.AutoFill Destination:=Range("C4:C293"), Type:=xlFillDefault 
 Range("C4:C293").Select 
 Sheets("Upload").Select 
 Windows("TemplateCreation.xls").Activate 
 Selection.Copy 
 Windows("FT Bi Test1").Activate 
 Windows("TemplateCreation.xls").Activate 
 Range("G" & Rows.Count).End(xlUp).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("FT Bi Test1").Activate 
 Sheets("Exception Report").Select 
 Range("E1").Select 
 ActiveSheet.Paste 
 Sheets("Upload").Select 
 Range("B2").Select 
 Application.CutCopyMode = False 
 ActiveCell.FormulaR1C1 = "=CONCATENATE(R3C1,'Exception Report'!R1C5,""F"")" 
 Selection.AutoFill Destination:=Range("B2:B291"), Type:=xlFillDefault 
 Range("B2:B291").Select 
 Selection.Copy 
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ 
 :=False, Transpose:=False 
 Cells.Select 
 Range("A2").Activate 
 Cells.EntireColumn.AutoFit 
 Range("A2").Select 
 'Protection
 Sheets("Summary Sheet").Select 
 ActiveSheet.Unprotect Password:="letmein" 
 Cells.Select 
 Selection.Locked = True 
 Selection.FormulaHidden = False 
 Range("A300").Select 
 Range(Selection, Selection.End(xlUp)).Select 
 numRows = Selection.Rows.Count 
 numColumns = Selection.Columns.Count 
 ActiveCell.Offset(1, 0).Select 
 Selection.Resize(numRows - 1, numColumns + 3).Select 
 Selection.Locked = False 
 Selection.FormulaHidden = False 
 Range("AE11:AG300").Select 
 Selection.Locked = False 
 Selection.FormulaHidden = False 
 ActiveSheet.Protect Password:="letmein" 
 ChDir _ 
 "\\fl-jax-files\Groups$\HR Corp\HRIS Analyst\!!!Time & Attendance\Recaps" 
 ActiveWorkbook.SaveAs Filename:= _ 
 "\\fl-jax-files\Groups$\HR Corp\HRIS Analyst\!!!Time & Attendance\Recaps\FT " & name & ".xls" _ 
 , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ 
 ReadOnlyRecommended:=False, CreateBackup:=False 
 ActiveWorkbook.RunAutoMacros Which:=xlAutoClose 
 ActiveWindow.Close 
 Selection.AutoFilter 
 Else 
 End If 
 Loop 
 MYCOUNTER = 100 
 Do Until MYCOUNTER > 254 ' START LOOP
 Selection.AutoFilter Field:=7, Criteria1:=MYCOUNTER + 1 
 MYCOUNTER = MYCOUNTER + 1 
 Range("I1").Value = MYCOUNTER 
 Selection.AutoFilter Field:=5, Criteria1:="S3R" 
 Selection.AutoFilter Field:=6, Criteria1:="P" 
 Range("A1").Select 
 Range("A" & Rows.Count).End(xlUp).Select 
 If ActiveCell.Value <> "Name" Then 
 Set name = Range("H" & Rows.Count).End(xlUp) 
 Range("J1").Value = name 
 Columns("A:A").Select 
 Range("A:H").Sort Key1:=Range("A1"), Order1:=xlAscending, Header:= _ 
 xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ 
 DataOption1:=xlSortNormal 
 Workbooks.Add Template:= _ 
 "C:\Documents and Settings\kfurbush\Application Data\Microsoft\Templates\PT Bi Test.xlt" 
 ActiveSheet.Unprotect Password:="letmein" 
 Windows("TemplateCreation.xls").Activate 
 Range("A2:D" & Range("A" & Rows.Count).End(xlUp).Row).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("PT Bi Test1").Activate 
 Range("A13").Select 
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ 
 :=False, Transpose:=False 
 Windows("TemplateCreation.xls").Activate 
 Range("H" & Rows.Count).End(xlUp).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("PT Bi Test1").Activate 
 Range("A9:B9").Select 
 ActiveSheet.Paste 
 'Add PG and BatchID
 Windows("TemplateCreation.xls").Activate 
 Range("E2").Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("PT Bi Test1").Activate 
 Sheets("Upload").Visible = True 
 Sheets("Exception Report").Visible = True 
 Sheets("Exception Report").Select 
 Range("C4").Select 
 ActiveSheet.Paste 
 Range("C4").Select 
 Application.CutCopyMode = False 
 Selection.AutoFill Destination:=Range("C4:C293"), Type:=xlFillDefault 
 Range("C4:C293").Select 
 Sheets("Upload").Select 
 Windows("TemplateCreation.xls").Activate 
 Range("G" & Rows.Count).End(xlUp).Select 
 Application.CutCopyMode = False 
 Selection.Copy 
 Windows("PT Bi Test1").Activate 
 Sheets("Exception Report").Select 
 Range("F1").Select 
 ActiveSheet.Paste 
 Sheets("Upload").Select 
 Application.CutCopyMode = False 
 Application.CutCopyMode = False 
 Range("B2").Select 
 ActiveCell.FormulaR1C1 = "=CONCATENATE(RC1,'Exception Report'!R1C6,""P"")" 
 Selection.AutoFill Destination:=Range("B2:B300"), Type:=xlFillDefault 
 Range("B2:B300").Select 
 Selection.Copy 
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ 
 :=False, Transpose:=False 
 Cells.Select 
 Range("A2").Activate 
 Cells.EntireColumn.AutoFit 
 Range("A2").Select 
 'Protection
 Sheets("Summary Sheet").Select 
 ActiveSheet.Unprotect Password:="letmein" 
 Cells.Select 
 Selection.Locked = True 
 Selection.FormulaHidden = False 
 Range("A300").Select 
 Range(Selection, Selection.End(xlUp)).Select 
 numRows = Selection.Rows.Count 
 numColumns = Selection.Columns.Count 
 ActiveCell.Offset(1, 0).Select 
 Selection.Resize(numRows - 1, numColumns + 3).Select 
 Selection.Locked = False 
 Selection.FormulaHidden = False 
 Range("AE11:AG300").Select 
 Selection.Locked = False 
 Selection.FormulaHidden = False 
 ActiveSheet.Protect Password:="letmein" 
 ChDir _ 
 "\\fl-jax-files\Groups$\HR Corp\HRIS Analyst\!!!Time & Attendance\Recaps" 
 ActiveWorkbook.SaveAs Filename:= _ 
 "\\fl-jax-files\Groups$\HR Corp\HRIS Analyst\!!!Time & Attendance\Recaps\PT " & name & ".xls" _ 
 , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ 
 ReadOnlyRecommended:=False, CreateBackup:=False 
 ActiveWorkbook.RunAutoMacros Which:=xlAutoClose 
 ActiveWindow.Close 
 Selection.AutoFilter 
 Else 
 End If 
 Loop 
 Application.ScreenUpdating = True 
 Application.DisplayAlerts = True 
End Sub 

@benbendedeilem
Cevapla


ozanakkaya
sledgeab
Kullanici Avatari
Kurucu
O.... A....
9.009
29/01/2008
Denizli
Memur
Ofis 2010 32 Bit
Bugün,20:17
Paylaşım için teşekkürler.
Cevapla







Konuyu Okuyanlar: 1 Ziyaretçi


Konu ile Alakalı Benzer Konular
Konular Yazar Yorumlar Okunma Tarih Son Yorum
  Apartman Yöneticileri için excel programı. assenucler 49 26.210 15/11/2016, 15:37 simendifer
  Excel UserForm'dan Access Veritabanı Yönetimi ve Access Rapor Kullanımı ogulcan92 6 4.986 24/06/2016, 12:03 firstisland
  Excel Cari Takip Programı yusuftym 3 2.163 30/05/2016, 13:53 maviturna
  Excel Raporlama Programı (VBA) sturan2 10 14.773 30/05/2016, 13:51 maviturna
  Oğulcan Excel Web Sitesi ogulcan92 22 14.753 18/05/2016, 10:29 ozanakkaya


Türkçe Çeviri: MCTR, Forum Yazılımı: MyBB, © 2002-2016 MyBB Group.
DMCA.com Protection Status
© Desing by XSTYLED| Develops by ozanakkaya