02-17-2011, 12:27 AM
Good afternoon.
I'm hoping someone can help me figure this one out.
I'm accessing an excel sheet using QTP. Getting some values off the spreadsheet...
The excel sheet is on a SharePoint site and it appears QTP is able to check the doc out.
The issue is, I don't know how to have QTP check the doc back in...
or...
Can anyone help me access the excel sheet without checking it out (read only) would work.
Here is my code.
I'm hoping someone can help me figure this one out.
I'm accessing an excel sheet using QTP. Getting some values off the spreadsheet...
The excel sheet is on a SharePoint site and it appears QTP is able to check the doc out.
The issue is, I don't know how to have QTP check the doc back in...
or...
Can anyone help me access the excel sheet without checking it out (read only) would work.
Here is my code.
Code:
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.WorkBooks.Open("http://path.xlsx")
Set objDriverSheet = objWorkbook.Worksheets("sheet1")
Row = 1
Do until objDriverSheet.Cells(row,"A").Value = ""
TeWindow("TeWindow").TeScreen("Entry").TeField("Field").Set objDriverSheet.Cells(row,"A").Value
Row = Row + 1
Loop