Hi all, I need to insert a Visual Analytics report (2G) in a Microsoft Excel Workbook, automating it using the SAS Add-In 8.2 for Microsoft Office and VBA code. The server where the report is saved is https://vsmartanalytics.intranet.mycompany.eu and the path within the server is /DataGovernance/Teamxxx/Reports/ReportName This is the dialog box which appears when I click on Reports in the Excel workbook Note that the reports are not on a SAS Folder but on a Visual Analytics server, if you click on "SAS Folders" it's empty, but I think the only method I can use to insert the report with VBA code is InsertReport2GFromSASFolder. I tested it with this routine Sub InsertReport2G() Dim sas As SASExcelAddIn Dim report As SASReport2G Set sas = Application.COMAddIns.Item("SAS.ExcelAddIn").Object Set report = sas.InsertReport2GFromSASFolder("https://vsmartanalytics.intranet.mycompany.eu/DataGovernance/Teamxxx/Reports/ReportName", Sheet1.Range("A1")) End Sub but it doesn't work and returns a Runtime Error '2146232832 (80131600)'. I added the reference and the HelloWorld method works, maybe the string I inserted for the path is wrong, or it's the wrong method, I don't know. Can you help me, please? Thank you
... View more