Hello, I would like to know if there is a way to download a BO Webi Report (OpenDocument) via VBA with Office Access or Excel. Right now I can Login to BO Webi and open the desired Webi OpenDocument Report with the following VBA Code:
[1]: https://i.stack.imgur.com/p30uV.png
Private Sub btnReportBO_Click()
WebBrowser.navigate "https://xxxxxx.com/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FjkfNFtyyg4ABJEBAABnyuNvAFBWgRcs"
End Sub
Private Sub WebBrowser_DocumentComplete(ByVal pDisp As Object, url As Variant)
With WebBrowser
If .Document.title = "OpenDocument" Then
.Document.all("_id0:logon:USERNAME").Value = strUsername
.Document.all("_id0:logon:PASSWORD").Value = strPassword
Do: Loop Until .Document.ReadyState = "complete"
.Document.all("_id0:logon:logonButton").Click
End If
End With
End Sub
After that how can download the table?
[2]: https://i.stack.imgur.com/OVe8k.png
I fail because I don't know how to access the Frame or iFrame containing the table. If I download the HTML source code via right click - View Source to my Desktop then I can Export the table to Access.
How can I Access the Report/Table in the Document Frame via VBA?
Or How can I download the entire source code to an text file?