I am gettig an error while my macro paste's something in the mentioned file.
please can some one help me solve the error.
macro pasted below.
Sub tg()
Set xlApp = New Excel.Application
Set xlApp1 = New Excel.Application
Set xlApp2 = New Excel.Application
Set xlApp3 = New Excel.Application
xlApp.Visible = True
xlApp1.Visible = True
xlApp2.Visible = True
xlApp3.Visible = True
Set xlBook = xlApp.Workbooks.Open("I:\GoPricing\Tofiq\global_imagine.csv")
If ActiveSheet.UsedRange.Rows.Count > 150000 Then
Application.CutCopyMode = False
'xlApp.Range("A2").Select
xlApp.Rows("2:75000").Select
xlApp.Selection.Copy
Set xlbook1 = xlApp1.Workbooks.Open("I:\GoPricing\Tofiq\Milenium-Cleanup1.xlsm")
xlApp1.Range("A2").Select
xlApp1.ActiveSheet.Paste
xlbook1.Save
' xlbook1.Close
xlApp.Workbooks(1).Activate
Application.CutCopyMode = False
xlApp.Rows("75001:150000").Select
xlApp.Selection.Copy
Set xlbook2 = xlApp2.Workbooks.Open("I:\GoPricing\Tofiq\Milenium-Cleanup2.xlsm")
xlApp2.Range("A2").Select
xlApp2.ActiveSheet.Paste
xlbook2.Save
' xlbook2.Close
xlApp.Workbooks(1).Activate
Application.CutCopyMode = False
xlApp.Rows("150001:250000").Select
xlApp.Selection.Copy
Set xlbook3 = xlApp3.Workbooks.Open("I:\GoPricing\Tofiq\Milenium-Cleanup3.xlsm")
xlApp3.Range("A2").Select
xlApp3.ActiveSheet.Paste
Application.CutCopyMode = False
xlbook3.Save
' xlbook3.Close
xlBook.Close
Else
Application.CutCopyMode = False
'xlApp.Range("A2").Select
xlApp.Rows("2:75000").Select
xlApp.Selection.Copy
Set xlbook1 = xlApp1.Workbooks.Open("I:\GoPricing\Tofiq\Milenium-Cleanup1.xlsm")
xlApp1.Range("A2").Select
xlApp1.ActiveSheet.Paste
xlbook1.Save
' xlbook1.Close
xlApp.Workbooks(1).Activate
Application.CutCopyMode = False
xlApp.Rows("75001:150000").Select
xlApp.Selection.Copy
Set xlbook2 = xlApp2.Workbooks.Open("I:\GoPricing\Tofiq\Milenium-Cleanup2.xlsm")
xlApp2.Range("A2").Select
xlApp2.ActiveSheet.Paste
xlbook2.Save
' xlbook2.Close
End If
End Sub
Bookmarks