I’ve developed a lot of macros for my company recently, while also working on implementing the macros into robots. The more macros I develop the harder it is to manage the code for all of them, so I was hoping it would be possible to make use of the “Invoke VBA” activity in order to split all the code into files I can source control, while also moving all responsibility of execution to the robot.
Now as VBA is not the same as VB, and although I save the macro files with the .vb extension, I’m unsure on how to go about, or if it is even possible to reference other .vb files from one. The main reason is that I have moved a lot of repetitive tasks into modules, that I can easily reference within my macros workbook. But if I move these macros to .vb files to invoke, is there a way for me to create these ‘utility’ methods in a file, and reference this file within the other macro files?
Thanks for your help,