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
#2
Not Solved
did you try using the Workbook object format?

Code:
Set objWorkBook = objExcel.WorkBooks.Open("http://path.xlsx",false,true) 'file, convert, readonly
Reply
#3
Not Solved
Hadn't done that yet. I'll plug it in, see if SharePoint likes the options

Thanks,
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  spell checking of web objects kriday 3 3,958 07-05-2013, 01:37 PM
Last Post: Staff
  css sprited image checking gerfred 0 1,562 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,343 09-17-2012, 03:50 PM
Last Post: visitjaga
  QTP 9.2 Checking values in a dropdown list Poonam 5 21,053 11-29-2011, 04:40 PM
Last Post: vibhakhandelwal
  QTP compatibility with Sharepoint vibhakhandelwal 0 3,799 09-10-2011, 04:17 PM
Last Post: vibhakhandelwal

Forum Jump:


Users browsing this thread: 1 Guest(s)