Microstation Connect VBA Batch Process Error
Hi, Been coding in VBA for a couple of years, and know I have a new problem I have never seen before. I have a VBA-tool to scan a model and print file/object information to Excel. All works fine, but when I run my code with Batch process to loop several…
[MSTN CE U16 VBA] Read excel file from ProjectWise?
Hi Everyone,
I created a vba script that reads the values of an excel spreadsheet, it works pretty well and the spreadsheet is saved on my local drive.
My question is we are working in ProjectWise and what I would like to do is save the spreadsheet…
OpenBuildings Designer - Adding Links To Elements
OpenBuildings Designer allows us to enhance the data stored in our design files by giving us the opportunity to directly link eternal files to elements located within our design.
To add a link to an element, all we have to do is right click on the element…
MACRO FOR GENERATING WIND LOAD IN STAAD PRO
any one have the macros excel sheet prepared by mr. Surojit Ghoesh
pl mail me at gauravmandage143@gmail.com
gINT alternative in OpenRoads Designer
Hi,
I am a geotechnical engineer and I am using Openrails and OpenRoads designer. Our company has a license for both software, but no license for gINT toolbox. I wonder if there is any possibility to substitute gINT with some tool that does not need…
Integration of STAAD into Excel
Hi I have been working in STAAD for a very long time and have been extracting datas via excel from staad and paste it in a seperate sheet. I would like to automate the procees where the datas can be extracted from STAAD after the analysis process. This…
Define the values entered in excel as input values
Is there a way to define the values entered in excel as input values in AutoPIPE?
PWDM Cover letter - how can I change the pdf format to excel?
our current coversheet only provides pdf format
we have excel template in overall settings, but when a transmittal is created coversheets are in pdf format.
As it's not user-friendly to copy over the meta data from pdf, I'm trying to find a way…
Usando ModelBuilder para Importar Dados Externos
Produto(s):
WaterCAD, WaterGEMS, SewerGEMS, SewerCAD, StormCAD, PondPack, CivilStorm, HAMMER
Versão(ões):
CONNECT Edition, V8i
Área:
Modelagem
Visão geral
ModelBuilder é uma ferramenta disponível nos produtos Bentley OpenFlows…
[OpenRail Designer Realease 3] Geotechnical - Unable to choose Excel to load Database Type in Database Connectivity and Mapping
Hello,
I am learing Geotechnical tool in OpenRail Designer Release 3. In your tutorial, in Database Connectivity and Mapping window, it is shown that you can define Database type from:
Microsoft Access based (.gpj) file,
Microsoft Excel
SQL…
Importing Geotechnical data into ORD using an excel file.
Hello there.
I am currently working in the geotechnical ribbon workflow. I have an excel file of all the information needed for the required Borehole tab (e.g., Easting , Northing , Elevation , and Hole Depth ). Also, in the excel file I have the l…
Q. Displacement values in the excel pivot table output from MDB file are doubled when using AutoPIPE, why?
Applies To
Product(s):
AutoPIPE
Version(s):
ALL;
Area:
Report
Date Logged & Current Version
April 2023 23.00.00.230
Problem:
Displacement values at a tee point in the excel pivot table output from MDB file are…
02. Excel Reports from Report Manager in AutoPIPE
Comments and questions about creating a MS Word report
1. Create an Excel reports
2. Excel Pivot tables
See Also
Report Manager reports FAQ
Bentley AutoPIPE
How to add own properties (Definitions) to Solid object
Hi,
I have created my own definitions and I would like to fill this data by nodes (using excel file) - during creating solids or after that. Is it possible? I know how to set it manually by this function (bellow) but I wonder to do that more automatically…
09. How quickly insert SAM load case and settings quickly using AutoPIPE?
Applies To
Product(s):
AutoPIPE
Version(s):
ALL;
Area:
Modeling
Date Logged & Current Version
March 2023 12.08.04.009
Problem:
How quickly insert SAM load case and settings quickly using AutoPIPE?
Solution…
Can't Synchronise from Excel
Hi,
I managed to import some resource user fields from excel once before. Now there have been updates and i'm trying to use "synchronise from" in external data to update these resource user fields and the import keeps failing.
Error: The required…
import data from excel
i was trying to import data from a excel file but i had some troubles with the number when i imported them .. i conformed that the numbers type in excel are number because the user field is also a number type . but i got a big number as you can see in…
Data Template Excel Macros
If you see this PROTECTED VIEW message, please click on Enable Editing .
LEGION Data template needs Excel macros.
For Data template from LEGION 2023 version.
To enable macros, please change macro settings in the Trust Center.
Click the File…
How to copy data from a profile or graph and retain column headers
Product(s):
WaterGEMS, SewerGEMS, CivilStorm, StormCAD, PondPack, SewerCAD, HAMMER, WaterCAD
Version(s):
CONNECT Edition, V8i
Area:
Output and Reporting
Problem
How can I copy graph or profile data so it can be pasted…
Output to Excel table with several worksheets
Is it possible to output or export data from multiple gINT tables to Excel so each table is exported into distinct Excel worksheet? I`m able to setup excel output but I can`t find any solution to create excel table with more than one worksheet. Any advice…
Can I reference an excel file on projectwise explorer into another excel file?
I am trying to reference information from one excel file stored on projectwise into another, also stored on projectwise. Excel defaults to referencing the temporary copy on your local drive, meaning anyone else that checks out the file won't be able to…
Office 365 in der speedi.ini für den Excel und Word Export ergänzen
Produkt(e):
OpenBuildings Speedikon
Version(en):
CONNECT Edition
Produktbereich:
Berechnungen
Produktunterbereich:
Mengen
Hintergrundinformation
Bei der Übergabe der Mengen an Excel kann in Speedikon…
Could not obtain data from data source when using Place Table from Excel File
Product:
MicroStation
Version:
CONNECT
Environment:
Windows 10, Windows 11
Area:
N/A
Subarea:
Tables
Problem
When placing a table from an Excel file, the following message appears.
The table…
Probleme beim Excel oder Word Export
Produkt(e):
OpenBuildings Speedikon
Version(en):
CONNECT Edition
Produktbereich:
Allgemein
Produktunterbereich:
N/A
Fehlermeldung oder Warnhinweis
Excel und Word Export funktionieren nicht korrekt. Es…
No Rows returned from... message appears when generating an Excel Report using AutoPIPE, why?
Applies To
Product(s):
AutoPIPE
Version(s):
ALL;
Area:
Warning Message
Date Logged & Current Version
Nov 2022 12.08.03.015
Problem:
The following is displayed when using AutoPIPE
-----------------------…