Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Invalid procedure call or argument when using 2 excel sheet
#1
Solved: 10 Years, 9 Months 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: 10 Years, 9 Months 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,024 02-28-2019, 11:46 AM
Last Post: naruoga
  Invalid file error importing xls file Makhado 0 1,193 10-04-2018, 04:33 PM
Last Post: Makhado
  Reading data from excel sheet serenediva 1 8,824 03-03-2017, 10:07 AM
Last Post: vinod123
  The DataTable.ExportSheet operation failed. Invalid file. Niraj 2 5,974 05-05-2015, 11:40 PM
Last Post: babu123
Smile Importing Excel sheet - Reference Values are not recognized michiusa69 3 7,582 01-23-2015, 02:36 AM
Last Post: lkng2001

Forum Jump:


Users browsing this thread: 1 Guest(s)