Browse By Tags

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…

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…

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…

I am trying to pull ultimate factored moments for all beams in a project to a spreadsheet via RAM DA and VBA, but the IGravitySteel1.GetBeamDesignMoments is not working for lateral beams. What is the easiest way to pull lateral beam info similar to the…

Hello! I need to send Element information of selected objects (coordinates Start and End points) to the sertain List of Excel. How can I do it using VBA? Many thanks to all for your ideas! Artem

Hi Guys, I'm using Excel VBA to call Microstation and then from a list of directories open .pset files (previously created manually) contained within each directory. The intention is to open each pset, print to PDF and move onto the next PSET until…

Hi, I have been using a VBA script run from Excel which formats tables, creates dgn files from the list and and then pastes those tables as embedded objects into new dgn drawing. I had to use the self closing popup as a divided between copy in Excel…

Hello ... I've just installed "STAAD.Pro Advanced CONNECT Edition - Version 21.03.00.146" on my workstation and now I can't find the "OpenSTAADUI.tlb" library to run the Excel VBA macros !! ... please advise asap with thanks

I am creating an application in Microsoft Excel (2016) that will open a Power Geopak V8i (8.11.9.878) drainage project file (.gdf) and extract data from it. I have referenced both the Microstation and Geopak VBA references in my Excel project. It is my…

I am creating an application in Microsoft Excel (2016) that will open a Power Geopak V8i (8.11.9.878) drainage project file (.gdf) and extract data from it. I have referenced both the Microstation and Geopak VBA references in my Excel project. It is my…

greetings. I Need one suggestion/ Help . i Have Few hundred microstation dgn files which are having only title blocks at one folder in Drive. Each Dgn file has multiple reference attached to it. all reference files are some Drawings. at a time only…

I have many DGN drawings. I want update tittle block on each drawing to edit on text according to excel file.

Hi, I am trying to get started with openSTAAD.I have tried in excel and the built in editor in STAAD.I get an error when trying to instantiate the open staad library. I have Staad open to a new file. I have tried the flowing code in VBA for Excel…

Hi all, Recently updated my SelectSeries4 to CONNECT and I am having issues creating a design file using the following code Sub Test() Dim o As MicroStationDGN.Application Dim oAL As ApplicationObjectConnector Dim myDGN As DesignFile Set oAL…

Hi all, I'm looking at creating a complex chain/line element around the most outer edges of the shape I've attached below. My macro is written in excel VBA What commands should I be looking at to achieve this? I'm having a bit of difficulty because…

Hi all, I'm new to microstation VBA coding and would like everyones input on my problem. My VBA code in Excel does the following 1. Opens and creates a microstation DGN file named "DrawPoints" 2. Iterates through coordinate values in excel sheet and…

Hi all, I want to write a VBA macro which will allow me to draw a perpendicular line from the nearest located element (located from the known point) to a known point. Illustration below Here are my questions 1. How do I locate the nearest element…

Hi all, I'm new to VBA coding in Microstation and currently trying to create a parabola in microstation based on an array of coordinates in excel. The coordinates reflect the Conic Curve (Parabola) tool in Microstation taking the start, end and shoulder…

I was trying to use Data Access Com in EXCEL VBA to get member forces in Columns. I was trying to get AnalysisCaseIDs for IForces.GetMemberForces, so I called IForces.GetAnalysisCasesIDArray and the EXCEL keep crashing. I looked up the function in the…

Hello I am writing a macro in Microstation that uses a lot of Excel VBA. It works fine on my machine, but whenever someone else tests it with different library present we obviously got crashes. Question is: is there a way (in code) to attach the…

Greetings STAAD fans, I am developing a VBA to the get the list of beams and after a couple of tries I have notice that the OpenSTAAD | GetBeamList command is not working. Any suggestions? See the following VBA Macro Sub GetBeamList() On Error…

I have some VBA code in an Excel spreadsheet where I am trying to open a dgn in order to do some editing: Dim oMSApp As MicroStationDGN.Application Dim myDGN As DesignFile Dim myFSO As New Scripting.FileSystemObject Dim myFile As Scripting.File …

Hi, Is there anyone who knows how to develop an Excel Spreadsheet that asks for building dimensions (geometry); and translate these dimensions into joint coordinates, and possibly member incidences to copy them over to STAAD Editor. The number of joints…