cocreateinstance

Hi all, I have put together this code which basically detects worksheet paste operations before they actually happen. This allows for manipulating the data while still in the clipboard as well as for cancelling the paste operation if so desired. I have used in this vba project some basic api...

Hi all, This is an attempt to simulate the Windows built-in screen-reader narrator but, done with vba alone. The code is supposed to read-back the type of object currently under the mouse pointer and, if applicable, to read the object caption\text\value as well. The code lets you choose a...

Hi dear excel enthusiasts, The following little project makes your excel userform look like a standalone application by hiding the main excel window and leaving only the userform with a personalised icon added to it that shows on the TaskBar instead of the native excel icon ? The code makes...

Hi all, I've been reading on COM and how to connect to automation servers and query their Properties and Methods. As far as I know, this is done via the IDispatch Interface through which the Server application exposes its Properties and Methods. This way of handling automation is obviously...