This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Want to learn VBA for Microstation, Online Coarse or book, or VB scripting.

I want to learn to make program using VBA for Microstation. I would prefer to learn VBA not MDL since I would use that language or Excel or any other windows programs. I found a college coarse for Introductory to VBA. Which is not geared to any one windows program like Microstation. I assume this is not the best coarse to teach me how to program for Microstation. Any advise what kind of coarse I should be looking for, maybe VB scripting?  I am not quite clear what is the difference between VBA vs VB scripting.  Maybe some kind of training book instead?

 I want to automate some routine task we do in Microstation. I have learned to program from a book before, with AutoLisp (autocad), which I greatly enjoyed. So I have some experience in programming. I am hoping to ideally spend 40hours learning VBA through a coarse or book, not sure if that is realistic. Any advise of what kind of coarse or book. If VBA scrip is the way for me, where can I find a coarse or which tutorial book would you recommend. Thanks.

Parents
  • Hello lbbss,
    There is a pretty good guide delivered with MicroStation located in the
    MicroStationVBA.chm file.

    Don't know of any VBA for MicroStation classes but there is a good book for
    learning:

    Learning MicroStation VBA by Jerry Winters published by Bentley Institute
    Press

    You can order it from Amazon or Bentley for about $90

    > I want to learn to make program using VBA for Microstation. I would
    > prefer to learn VBA not MDL since I would use that language or Excel
    > or any other windows programs. I found a college coarse for
    > Introductory to VBA. Which is not geared to any one windows program
    > like Microstation. I assume this is not the best coarse to teach me
    > how to program for Microstation. Any advise what kind of coarse I
    > should be looking for, maybe VB scripting? I am not quite clear what
    > is the difference between VBA vs VB scripting. Maybe some kind of
    > training book instead?
    >
    > I want to automate some routine task we do in Microstation. I have
    > learned to program from a book before, with AutoLisp (autocad), which
    > I greatly enjoyed. So I have some experience in programming. I am
    > hoping to ideally spend 40hours learning VBA through a coarse or book,
    > not sure if that is realistic. Any advise of what kind of coarse or
    > book. If VBA scrip is the way for me, where can I find a coarse or
    > which tutorial book would you recommend. Thanks.
    >
  • Actually, there are onDemand eLearning courses for MicroStation VBA -- those can be found starting on http://www.bentley.com/en-US/Training/Products/Resources/Books/

    More details on the "Learning MicroStation VBA" Bentley Institute book mentioned can be found on http://www.bentley.com/en-US/Training/Products/Resources/Books/Learning+MicroStation+VBA.htm

      

  • I bought the Microstation vba book from Bentley Institute Press that came with a CD, but the cd is blank.   Can someone post this file on this forum.   I can see it has some data on the cd, due to the lines that are burned on the data side.   I tried both windows explorer and Microstation VBA Project manager, but no luck.   The cd is clean and no scratches.   I bought it about a year ago, but have not had time till now to get into it.    Phil not sure if you have this in your library.    thanks. 

    this is the book I have 

    http://www.bentley.com/en-US/Training/Products/Resources/Books/Learning+MicroStation+VBA.htm  

  • There is a lot of stuff on that CD, way too much to "post this ... on this forum". Please contact me (offline) with your contact information and we will look into getting another CD out to you.

      

  • wow, that was quick.   Ok I found your email, will send you my info.  tx

  • I recently bought the book By Gerry Winters (learning MicroStation VBA) and I am really disappointed, I have very little VBA skills and I was hoping to improve them by purchasing this book. Everything went smoothly until chapter 5. I followed all the instructions in Chapter 5, Modules, Forms and Class Modules. I discovered that there are some steps left out in his instruction or else he did not properly review this part. He does not properly explain the steps to get this exercise working. If you have to try and follow this exercise step by step you will discover that it is absolute gibberish to a beginner.

  • Microsoft VBA is derived from Microsoft Visual Basic (VB).  Microsoft provide a VBA Toolkit so other parties, such as Bentley Systems, can incorporate VBA into their products.  As a result, MicroStation VBA is similar to other VBAs.

    Features common to all VBAs include the Interactive Development Environment (IDE), the various module types (Modules, Forms and Class Modules) and the language syntax.  The way the various VBAs differ is in the extensions they offer for a specific application.  For example, Word VBA offers ways to handle paragraphs of text; Excel VBA provides ways to handle data in a worksheet; MicroStation VBA provides ways to manipulate graphic elements in a DGN model.

    Look at other VBAs

    If you're struggling with MicroStation VBA, take a look at the way other vendors do it.  While there's only the one book about MicroStation VBA, there are plenty of others that provide sound advice for Word VBA, Excel VBA, etc.  There are also plenty of websites that deal with VB/VBA.

    I find that when one viewpoint doesn't help me understand a technical issue, often another viewpoint approaches the subject in a different way.  That different approach may illuminate a topic and lead you to that Bingo! moment.  Get hold of  a book about Excel VBA, and see if that discusses Modules, Forms and Class Modules in a way that is more enlightening for you.

     
    Regards, Jon Summers
    LA Solutions

Reply
  • Microsoft VBA is derived from Microsoft Visual Basic (VB).  Microsoft provide a VBA Toolkit so other parties, such as Bentley Systems, can incorporate VBA into their products.  As a result, MicroStation VBA is similar to other VBAs.

    Features common to all VBAs include the Interactive Development Environment (IDE), the various module types (Modules, Forms and Class Modules) and the language syntax.  The way the various VBAs differ is in the extensions they offer for a specific application.  For example, Word VBA offers ways to handle paragraphs of text; Excel VBA provides ways to handle data in a worksheet; MicroStation VBA provides ways to manipulate graphic elements in a DGN model.

    Look at other VBAs

    If you're struggling with MicroStation VBA, take a look at the way other vendors do it.  While there's only the one book about MicroStation VBA, there are plenty of others that provide sound advice for Word VBA, Excel VBA, etc.  There are also plenty of websites that deal with VB/VBA.

    I find that when one viewpoint doesn't help me understand a technical issue, often another viewpoint approaches the subject in a different way.  That different approach may illuminate a topic and lead you to that Bingo! moment.  Get hold of  a book about Excel VBA, and see if that discusses Modules, Forms and Class Modules in a way that is more enlightening for you.

     
    Regards, Jon Summers
    LA Solutions

Children
No Data