Checking docs into Sharepoint using QTP

Checking docs into Sharepoint using QTP - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Checking docs into Sharepoint using QTP (/Thread-Checking-docs-into-Sharepoint-using-QTP)

Checking docs into Sharepoint using QTP - Brian.Osborne - 02-17-2011

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.

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

RE: Checking docs into Sharepoint using QTP - jsknight1969 - 02-17-2011

did you try using the Workbook object format?

Code:
Set objWorkBook = objExcel.WorkBooks.Open("http://path.xlsx",false,true) 'file, convert, readonly

RE: Checking docs into Sharepoint using QTP - Brian.Osborne - 02-17-2011

Hadn't done that yet. I'll plug it in, see if SharePoint likes the options

Thanks,