Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Invalid procedure call or argument when using 2 excel sheet
#1
Solved: 11 Years, 4 Months, 3 Weeks ago
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
Code:
if i-b1
Set xlWrkbk = xlApp.Workbooks.Open("C:\zip1.xls")
else if
Set xlWrkbk = xlApp.Workbooks.Open("C:\zip1.xls")
end if
I am using the same object and sheets for both excel.Is it ok?

Any help?
Thank You
Uma
Reply
#2
Solved: 11 Years, 4 Months, 3 Weeks ago
Remove the sheet and work it again with new sheet,Solved
Uma
Solved
delete the old page and add the new page
Uma
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Click after CheckProperty to a WebElement passed via Function argument fails naruoga 0 1,170 02-28-2019, 11:46 AM
Last Post: naruoga
  Invalid file error importing xls file Makhado 0 1,453 10-04-2018, 04:33 PM
Last Post: Makhado
  Reading data from excel sheet serenediva 1 9,695 03-03-2017, 10:07 AM
Last Post: vinod123
  The DataTable.ExportSheet operation failed. Invalid file. Niraj 2 6,315 05-05-2015, 11:40 PM
Last Post: babu123
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,940 01-23-2015, 02:36 AM
Last Post: lkng2001

Forum Jump:


Users browsing this thread: 1 Guest(s)