Hello,For maintenance convenience, for reutilisability (of utilities and math modules / classes for example), and to avoid a too large project (.MVBA) file, I would like to split a quite large .MVBA project file (currently about 3 Mb) into many smallers MVBA projects.These smaller MVBA projects would be loaded in the same time by Microstation in the VBA IDE and would be able to exchange public Sub / Function / Form / Class / Variables between them.Unfortunately, I didn't found how to make this exchange working in the VBA IDE or in Microstation.Example : two projects are loaded in the IDE
Project_A.mvbaModule_A_01Public Sub f1()Project_B.mvbaModule_B_02Public Sub f2()When I call f1 from inside f2, I get an error (not found).Please, do you know the way to do what I expect ?Many thanks in advance for any advice.Bernard Chevalier (France)
You must add a VBA reference to each project that is used in another project. In your example, Project B references method f1 in Project A: you should reference Project A from Project B.
In the VBA IDE, use menu Tools|References to pop the References dialog. You will see your VBA projects in the list. Check the project(s) that you want to reference.
Regards, Jon Summers LA Solutions
Answer Verified By: Bernard Chevalier
Thank you very much Mr Jon Summers for your answer.
I learned a lot about Microstation VBA reading your great website : http://www.la-solutions.co.uk/
As an alternate, you can send a key-in to Microstation to "vba run f2".
Super help, solved a problem for me on sharing a Variable sFclose between projects. So appreciate all you smarter folks who take the time to help others. Was a big Help ! ! ! !
Version: MicroStation V8i SS 10
RJB Phillips III (Richard) Praise the Lord for His Mercy and grace in Christ Jesus