We have tried to link LibreOffice Basic to the DataGroup Explorer, using the delivered dataset and got this result: The spreadsheet is opened as a CSV-file and not as an XLS file format. If I open the AECOsim XLS-file “BuildingDesigner.xls” with LibreOffice I get following error message:
Note: LibreOffice Basic is not certified to be used with AECOsim Building Designer so the following notes are offered as a possible solution. Some Microsoft Excel based functionality may not operate as designed when Excel is not present.
The error message shows how “LibreOffice Basic” is called meaning it is not compatible to the VBA.The syntax of the VBA code is absolutely correct. The used conditional code:
#If VBA7 Then‘..#Else‘..#End If
It is used with CONNECT Edition to recognize, which version of VBA is used. E.g. VBA 7 is used with AECOsim CONNECT Edition and supports 32 and 64 Bit, VBA 6 is used for 32 Bit only and used with MS V8i generation.
The error message “If außerhalb einer Prozedur unzulässig” means “If outside of a procedure is invalid”.
So LibreOffice Basic does not allow this conditional declaration and obviously is not completely compatible with VBA which is how it is required in AECOsim Building Designer or Microsoft Office.
As a workaround, the conditional declaration could be avoided by creating 2 different VBA files for each case, but this is no guarantee that it will work correctly in all other areas.
From the MSCE Readme, the VBA components are required as described in readme here:
https://docs.bentley.com/LiveContent/web/pub.xql?c=t&action=home&pub=MicroStation%20ReadMe-v6&lang=en#docid=GUID-288FAFD8-1107-4FCB-9843-8BECC9099A06&addHistory=true&query=&scope=&tid=&filename=&resource=&inner_id=&toc=false&eventType=lcContent.loadDocGUID-288FAFD8-1107-4FCB-9843-8BECC9099A06
Microsoft Visual Basic for Applications coreMicrosoft Visual Basic for Applications localized