Hi folks. There's something I've been wanting to ask for a while related to VBA. It's not a pressing issue, just something I observed, was unable to find references online, and I'm quite curious about.
If one runs multiple instances of a VBA Application, each instance will be able to execute code independently from the other, as long as there are hardware resources.
But it both instances try, at the same time, to use CreateObject (or even New), the one who gets to be the first will block the other until object creation is finished. For "light" objects its barely noticeable. But if one's t…