Hi Peter Jones,
Jon Summers has provided some very experienced and well-guided advice for the current path of customization you have chosen/have to take.
For MicroStation VBA if the VBA/COM APIs do not provide the functionality needed, then (as Jon mentions…