Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Checking docs into Sharepoint using QTP
#1
Not Solved
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
Reply


Messages In This Thread
Checking docs into Sharepoint using QTP - by Brian.Osborne - 02-17-2011, 12:27 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  spell checking of web objects kriday 3 3,780 07-05-2013, 01:37 PM
Last Post: Staff
  css sprited image checking gerfred 0 1,481 01-29-2013, 03:46 PM
Last Post: gerfred
  How to capture the DATE from the Calendar control in a sharepoint application Simr 3 10,028 09-17-2012, 03:50 PM
Last Post: visitjaga
  QTP 9.2 Checking values in a dropdown list Poonam 5 20,782 11-29-2011, 04:40 PM
Last Post: vibhakhandelwal
  QTP compatibility with Sharepoint vibhakhandelwal 0 3,735 09-10-2011, 04:17 PM
Last Post: vibhakhandelwal

Forum Jump:


Users browsing this thread: 1 Guest(s)