- Katılım
- 6 Aralık 2006
- Mesajlar
- 72
- Excel Vers. ve Dili
- 2007 turkce
- Altın Üyelik Bitiş Tarihi
- 11-12-2019
kullandığım bir makro var ancak yavaş çalışıyor. Dosyalar ekte
Sub conn()
Dim S1 As Worksheet
Dim Kaynak As String
Kaynak = Application.ActiveWorkbook.Path & "/" & "POLATLITES" & ".xlsx"
'Application.ScreenUpdating = False
Set wbk = Workbooks.Open(Kaynak, True, True)
Dim S2 As Worksheet
Set S2 = wbk.Sheets("sayfa1")
SONS2 = S2.[A65536].End(3).Row
Set S1 = ThisWorkbook.Sheets("TESELLÜM")
SONS1 = S1.[A65536].End(3).Row
For SXC = 7 To SONS1
S1.Cells(SXC, 12) = 0
Next SXC
For X = 7 To SONS1 '1432
For T = 2 To SONS2
arah = S2.Cells(T, 16) 'Val(TextBox10.Value)
KTON = S2.Cells(T, 12)
If S1.Cells(X, 5) & "-" & S1.Cells(X, 6) = arah Then
S1.Cells(X, 12) = KTON + S1.Cells(X, 12)
End If
Next
Next
wbk.Close False
Set wbk = Nothing
Set S1 = Nothing: Set sh = Nothing
'Application.ScreenUpdating = True
MsgBox "FİRELİ PANCAR AKTARILMIŞTIR YUSUF ÇAM...", vbInformation, "İŞLEM TAMAM"
End Sub
Sub conn()
Dim S1 As Worksheet
Dim Kaynak As String
Kaynak = Application.ActiveWorkbook.Path & "/" & "POLATLITES" & ".xlsx"
'Application.ScreenUpdating = False
Set wbk = Workbooks.Open(Kaynak, True, True)
Dim S2 As Worksheet
Set S2 = wbk.Sheets("sayfa1")
SONS2 = S2.[A65536].End(3).Row
Set S1 = ThisWorkbook.Sheets("TESELLÜM")
SONS1 = S1.[A65536].End(3).Row
For SXC = 7 To SONS1
S1.Cells(SXC, 12) = 0
Next SXC
For X = 7 To SONS1 '1432
For T = 2 To SONS2
arah = S2.Cells(T, 16) 'Val(TextBox10.Value)
KTON = S2.Cells(T, 12)
If S1.Cells(X, 5) & "-" & S1.Cells(X, 6) = arah Then
S1.Cells(X, 12) = KTON + S1.Cells(X, 12)
End If
Next
Next
wbk.Close False
Set wbk = Nothing
Set S1 = Nothing: Set sh = Nothing
'Application.ScreenUpdating = True
MsgBox "FİRELİ PANCAR AKTARILMIŞTIR YUSUF ÇAM...", vbInformation, "İŞLEM TAMAM"
End Sub
Ekli dosyalar
-
1,001.6 KB Görüntüleme: 12
-
671.5 KB Görüntüleme: 8
Son düzenleme: