Skip to Content
0
Jul 04, 2018 at 03:34 PM

BO BI 4.2 SP5 Webi - OpenDocument Report download via VBA

2165 Views

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?