10-08-2011, 03:52 AM
Hi,
I am using 2 excel sheet.My script is perfectly fine with the first excel.
It is opening 2nd excel file and excuting all the rows and it is going again to the for loop and it is giving
"Invalid Procedure call or argument error"
In my case
I am using the same object and sheets for both excel.Is it ok?
Any help?
Thank You
Uma
I am using 2 excel sheet.My script is perfectly fine with the first excel.
It is opening 2nd excel file and excuting all the rows and it is going again to the for loop and it is giving
"Invalid Procedure call or argument error"
In my case
Code:
if i-b1
Set xlWrkbk = xlApp.Workbooks.Open("C:\zip1.xls")
else if
Set xlWrkbk = xlApp.Workbooks.Open("C:\zip1.xls")
end if
Any help?
Thank You
Uma