remote procedure call failed while saving an excel file through vbscript in testcomplete
I am getting "remote procedure call failed " error while saving an excel file through vbscript in testcomplete
Forum Discussion
5 Replies
can you post the code you getting error ...
look at the call stack where you get error what dose it shows you?
Possibly security settings in Excel need enabled?
https://support.microsoft.com/en-us/kb/282830
Is the sheet on the same machine or one you are trying to access remotely?
Dim objExcel, objWorkbook, objDriverSheet, columncount, rowcount,strReleaseDate,strReleasePswd
set objExcel = Createobject("Excel.Application")
Set objWorkbook = objExcel.WorkBooks.Open(exppath)
Set objDriverSheet = objWorkbook.Worksheets("TestCase")
for row_idx = 1 to rowcount
Stepnum = objdriversheet.cells(row_idx,1)
Stepdesc = objdriversheet.cells(row_idx,2)
.....objWorkbook.Save--[Getting error at this point]
NextIf it opens it OK, and reads data from it OK, but can't save it, that sounds like a write permission issue?
