Browse By Tags

  • Linked Excel Sheets No Longer Updating / Can No Longer Create Linked Excel Sheets

    Just discovered that my linked Excel sheets are no longer updating. When I delete and attempt to link the Excel sheet again, I'm getting the error message shown below. I've tried it with brand new Excel sheets and am still getting the same error.
  • Error: Linking a Excel Spreadsheet from ProjectWise in OpenRoads Designer by using the Place Table tool

    When using the Place Table tool to link a excel spreadsheet to the OpenRoads file, this error message appears (see below) and the spreadsheet is not imported in. The DGN file and excel spreadsheet are located in ProjectWise. Any help would be greatly…
  • Insert Excel spreadsheet into Catalogue

    Hi All, By using Open Building Designer, how can I link/insert Excel spreadsheet into Catalogue and show as 'link/file' in Properties? If it is not a correct way to do it in 'Catalogue', how to do it as long as the Excel can be link in the Properties…
  • Document Standards Using Explorer

    Product: MicroStation Version: CONNECT Edition Feature: Explorer The Situation Have you wanted to document your CADD standards resources such as Levels or Text Styles, but were not certain how to go about…
  • Reference Loads Excel

    Can you export reference loads to Results Database .mdb?
  • How to solve the Schedule edit in excel the cell is read only (OpenBuildingDesigner)

    Hi I face a question on modifying data in the schedule function. The field in "modify instance data" is available to edit. The data type(date or string) doesn't affect the cell becomes read-only or not, which I tried on in the picture below. I am…
  • Microstation Excel Linking - Moving File Locations

    I am creating master template files to be copied and relocated for different projects. The master MicroStation file has various links to the same master excel spreadsheet. When i copy both master files (microstation and excel) to a new location, the copied…
  • Asset Manager Descriptions

    I am trying to figure out how to utilize the Asset Management excel spreadsheet in order to export features in ORD as shapefiles. I go to the blank sheet within the main Asset Management, but I am only able to select the default ones (Stop Sign, Guardrail…
  • Importing Rules from Excel

    Hi there, I've got an excel file that contains 100's of production rates for various activities. I would like to import them into the Rules panel so that I can use them for Physical Quantity Dependent Task Durations. I've tried exporting everything…
  • AutoPIPE Coffee Corner Announcement

    Join me this month for the AutoPIPE Coffee Corner session to learn about AutoPIPE reporting options using tailored examples. AutoPIPE - Report Examples August 04, 2022 | 01:00 P.M. EDT Register Now! Bentley Coffee Corners are open to all Bentley users…
  • How to make a connection with excel in mvba in Microstation [Update 15]

    Hi everyone, I am currently trying to adjust a mvba that worked for V8i and make it usable in Microstation Connect. I understand that Microstation Connect is a 64 bit application and from the following post I understood that I need to activate the "Microstation…
  • Autopipe Local coordinate excel template

    Hi, I am using Autopipe connect v12, but do not appear to have the excel templates for importing coordinates. I have tried duplicating the template based on the tutorial but am receiving errors. Is there a copy of these templates available online?
  • 07. How to find the maximum stress and ratio for each combination and add to the Results Summary report in AutoPIPE?

    Applies To Product(s): AutoPIPE Version(s): ALL; Area: Date Logged & Current Version Juky 2022 12.08.01.010 Problem: Look at the "Result Summary" output report, notice that the reported sections are based…
  • Is there any way to export these properties of all elements to excel file?

    Software: Open building Designer
  • When I try to copy/paste results from the Post Processing tables into an Excel spreadsheet I get a message saying “Range too big” or “Selection is too large”

    Applies To Product(s): STAAD.Pro Version(s): CONNECT Edition Environment: ALL Area: Miscellaneous Subarea: Original Author: Phil Riegel, Bentley Technical Support Group…
  • Excel Object Creation Issue

    I have a script used to create new projects. Within it, I create an Excel object subsequently used by the New-PWRichProjectsFromSpreadsheet cmdlet. It's worked with no issue until recently when the New-Object -ComObject excel.application started throwing…
  • Exporter la liste des éléments d'un fichier DGN vers excel

    Contexte Quel est le moyen le plus simple d'exporter une liste d'éléments présents dans un fichier de conception ainsi que leur origine vers un simple format .csv ou similaire ? Étapes à suivre Cela peut être réalisé grâce à la fonction Rapports…
  • export-pwaccesscontroltoexcel and 365 Sensitivity Label

    Our organisation has recently started using the Office 365 Sensitivity labelling and mandate the application of a label prior to saving a document or sending an Outlook email. This appears to have blocked the Powershell function from being able to access…
  • Exporting and editing Item Types in Excel using Microstation script

    Hi, I'm currently looking for a way to export and edit Item Types of a large number of Microstation .dgn files using a script/macro in Excel (.csv). Is there a way to write a script to do this for multiple files (>400), instead of having to do it manually…
  • Error using the Place Table tool with an Excel spreadsheet

    Product(s): OpenBuildings Designer Version(s): Connect Edition Area: Platform Tools Problem Description When I use the Place Table tool with an Excel spreadsheet I am getting the error "Could not obtain data from…
  • Rules Engine and Excel

    Hi Everybody, The demand of using Excel to export/import the rules engine is annoying. It could be nice if the export format could be optional. It could be wonderful if I have the opportunity to export to a CSV or a Tab separated file. It's a company…
  • Exporting Building data from open Building energy simulator to excel.

    I would like to export the surface information / wall windows doors floor area into excel so that I can manipulate the data to download onto one-click LCA. I would like to export dynamic simulation resua\lts for CIBse overheating reports and use a variety…
  • Excel VBA to Modify Microstation DGN

    Hello, I am pretty new to using Excel VBA to modify microstation file. My goal is using the cell values in excel to update tag sets and turn on/off layers, and purge certain empty tags (in different tag sets and under different layers). I assume…
  • Borehole number orders when exporting as excel file

    Hi everyone, I have a set of boreholes logged with numbers varying between BH20-01 to BH20-301. My issue is that when I am exporting my gINT file in excel format, the gINT changes the order of the boreholes in tables. For example, BH20-112 shows up…
  • Beim Excel-Export und -Import funktionieren nur die Spalten mit dem Stiftsymbol - im Project Editor

    Produkt(e): OpenBuildings Speedikon Version(en): CONNECT Edition Umgebung: N\A Produktunterbereich: ProjektEditor Problem: Beim Re-Import nach der Bearbeitung aller Attribute im Projekteditor über den…