Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
OpenBuildings | AECOsim | Speedikon
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | Speedikon
  • More
  • Cancel
OpenBuildings | AECOsim | Speedikon
OpenBuildings | AECOsim | Speedikon Wiki Using LibreOffice Basic with AECOsim Building Designer
    • Sign in
    • Building Design - Wiki
    • +OpenBuildings Designer
    • OpenBuildings Station Designer
    • -AECOsim Building Designer
      • +Annotation - AECOsim Building Designer
      • +Architectural Design - AECOsim Building Designer
      • +ASM (Analytical Space Model)
      • +Configuration - AECOsim Building Designer
      • +DataGroup System - AECOsim Building Designer
      • +Dataset and Content - AECOsim Building Designer
      • +Drawing Extraction - AECOsim Building Designer
      • +Drawing Views - AECOsim Building Designer
      • +Electrical Annotation and Design - AECOsim Building Designer
      • +Floors - AECOsim Building Designer
      • +Form Modeling - AECOsim Building Designer
      • -General - AECOsim Building Designer
        • Accessing The Bentley Developer Network
        • AECOsim Building Designer - MicroStation Mode
        • AECOsim Building Designer - Version History
        • AECOsim Building Designer Product Compatibility
        • AECOsim MicroStation CONNECT Edition shortcut
        • AECOsim timeout in 2 minutes
        • Blurry dialogs in Windows 8-8.1
        • Change Rejected In Order To Preserve Design Integrity
        • Compatibility with Microsoft Office 64-bit - AECOsim Building Designer
        • CONNECT Edition - Can CONNECT Edition and V8i reside on the same machine?
        • CONNECT Edition - Cannot Open Drawing with Chinese Character
        • CONNECT Edition - City names written in Regional language are not properly shown in Light Manager
        • CONNECT Edition - DGN file format is unchanged
        • CONNECT Edition - Has the "Isolate" command been removed from AECOsim CONNECT?
        • CONNECT Edition - Installation Error - '.NET 4.5.2 '
        • CONNECT Edition - Installation Error - 'error code 0x80070643'
        • CONNECT Edition - Installation Error - 'Hash Mismatch'
        • CONNECT Edition - Is there any way to count all cells present in a drawing?
        • CONNECT Edition - What Features/Capabilities have been Deprecated/Superseded?
        • Creating a Geographic Coordinate System in BIM Projects
        • +Errors
        • Globally add data to every component in AECOsim
        • How can I get complete list of AccuDraw Shortcut Key-in?
        • How to modify Flyover Tool-tip
        • How to use "Swept Blend" function in AECOsim Building Designer
        • How to Use TFREBUILD
        • Ignore Clip Volumes not working
        • Inappropriate display issue in high resolution monitor
        • Issues after updating AECOsim Building Designer to Update 4
        • Lines going everywhere all over my drawing (zingers)
        • Lock Pages in Memory issue
        • Main Tasks Menu is Missing
        • Microsoft Office 365 August updates (version 1707) are causing crashes in AECOsim Building Designer on startup
        • Missing Help for Electrical
        • Open AECOsim Building Designer Files in MicroStation
        • Poor Performance when Operating System files are compressed
        • Recommended Solids Working Area Workflow
        • Regenerating preference files to help resolve random odd behavior
        • SelectBy Key-ins and Their Effect
        • Selecting Building Elements By Color
        • Slowness while placing cells
        • Soft Clearance function in the clash detection
        • Unable to select some elements in the 3d model
        • Using LibreOffice Basic with AECOsim Building Designer
        • What's New in Select Series 6 Update 1
      • +Grid Systems - AECOsim Building Designer
      • +HVAC Design - AECOsim Building Designer
      • +i-model - AECOsim Building Designer
      • +Import/Export - AECOsim Building Designer
      • +Installation - AECOsim Building Designer
      • +Modify - AECOsim Building Designer
      • +Platform Tools - AECOsim Building Designer
      • +Plumbing Design - AECOsim Building Designer
      • +Print/Plot - AECOsim Building Designer
      • +ProjectWise Integration - AECOsim Building Designer
      • +Settings/Attributes - AECOsim Building Designer
      • +Space Planner - AECOsim Building Designer
      • +Structural Design - AECOsim Building Designer
      • +Utilities - AECOsim Building Designer
      • +Workspace - AECOsim Building Designer
    • +GenerativeComponents
    • +OpenBuildings Energy Simulator
    • +Bentley Facilities Space Planner CONNECT Edition
    • +Bentley Speedikon
    • +iModel Plugin for Revit
    • +Social Distance Assessments
    • Working from home with OpenBuildings products
    • Working from home with Speedikon
    • +Special Interest Group (SIG) FAQs
    • +Structural Modeler_PS
    • +Configuration Explorer
    • +Legacy Products

     
     Questions about this article, topic, or product? Click here. 

    Using LibreOffice Basic with AECOsim Building Designer

      Product(s): AECOsim Building Designer
      Version(s): 08.11.09.866
      Environment: N/A
      Area: General
      Subarea: N/A

    Problem

    If I open “BuildingDesigner.xls” with LibreOffice Basic I get the following error message:

    "If outside of a procedure is invalid”

    Why am I seeing this error message?

    Solution

    The error message from the screenshot shows how “LibreOffice Basic” is not compatible with the VBA even though the syntax of the VBA code is correct.  The conditional code:

    #If VBA7 Then

    ‘..

    #Else

    ‘..

    #End If

    It is used by MicroStation CONNECT Edition to recognize which version of VBA should be called; e.g.,VBA 7 is used with MicroStation CONNECT Edition and supports 32 and 64 Bit, while VBA 6 is used with MicroStation V8i and supports 32 bit only.

    So LibreOffice Basic does not allow this conditional declaration because it is not completely compatible with VBA, which is how it is required in MicroStation and/or Microsoft Office.

    As a workaround, the error message could be avoided by creating 2 different VBA files for each case, but there is no guarantee that it will work correctly in all areas.

    From the MicroStation CONNECT Edition Readme, the VBA components are required as described here:

    https://docs.bentley.com/LiveContent/content/en/MicroStation%20ReadMe-v6/GUID-637B20A8-F57B-4FD0-9B4E-628574844438

    Note: Since LibreOffice Basic is not certified to be used with MicroStation, it is also not certified to be used with AECOsim Building Designer.

    • Share
    • History
    • More
    • Cancel
    • Gerard Torres Created by Gerard Torres
    • When: Thu, Nov 30 2017 6:01 PM
    • Gerard Torres Last revision by Gerard Torres
    • When: Thu, Dec 7 2017 12:25 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies