• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 111 subscribers
  • Views 3565 views
  • Users 0 members are here

Cannot open STAAD from Excel VBA Openstaad- Create Object - Regd

CVP CVP
Offline

Dear All,

I have done some coding using Excel OPENSTAAD. I used Set objOpenSTAAD = CreateObject("StaadPro.OpenSTAAD").


Usually when i execute the command, STAAD opens up by itself runs the analysis.

But all of sudden im getting run time 429 error. The analysis runs only after i have opened the STAAD. There is some way to bypass this to enable excel to open STAAD automatically. 

Thank You

  • 0 Offline
    In your code, you have used the Results object function. Most of the results Object functions of OPENSTAAD has been discontinued since version 2007 Build 03. There is no further development and support on the Results Object function. Our stress is on using the Application Object Functions – and all the modifications and corrections (if any) will go to the later. If you use any version after STAAD.Pro SS3, the results object function will not work properly. Please modify your code and change the results object functions to equivalent application object functions. For example, the modified OpenSTAAD functions will be:

    Set objopenstaad = GetObject(, "staadpro.openstaad")

    You can go through the OpenSTAAD manual (Help > Contents > OpenSTAAD Documentation) for more help.



  • 0 Offline in reply to Surojit Ghosh
    I'm actually having the same Error 429 when using openstaad. It worked in SS5, but now I get there error in SS6. The offending line is:

    Set objOpenSTAAD = GetObject(, "StaadPro.OpenSTAAD")

    Any hints? I went through the OpenSTAAD manual, but this is the line it said to use. Again, it worked until I upgraded to SS6.
Communities
Support and Services
Training and Learning
Social Media