In your opinion, is it worth the time to overcome a pretty steep learning curve it'll be better off doubling down on VBA?
Would it be better in professional perspective to learn C++? Would the C++ have any noticable performance gain over VBA, considering that interaction with a model in SW consumes most of the time? Would it be more convenient to interact with all three APIs at once, using C++? So some kind of UI is required for some scripts.
I've got to share scripts with my colleagues, who, understandably, don't want to deal with coding, errors and debugging. For now I have separate VBA scripts doing all this. Mentioned tasks would include taking data from one workbook, passing it to SW, rebuilding a model according to received data and saving it, pulling out model properties, writing them to another workbook and passing them to ACAD. I want to make all three programs to work together for some tasks in future, but I haven't tried doing it yet. As for now, I have written some scripts, used to exchange data between Excel workbooks and SW or ACAD.Įverything is fine, except for two things: VBA seemed to be a rational choice being not too complicated at first glance and integrated in all three programs. So, naturally, I've started to get into automation in order to preserve my sanity. In my work I have to iterate modeling/drawing creation a lot.