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, 10 Months, 1 Week 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


Messages In This Thread
Invalid procedure call or argument when using 2 excel sheet - by Uma - 10-08-2011, 03:52 AM

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

Forum Jump:


Users browsing this thread: 1 Guest(s)