cocreateinstance

Hi excel/vba enthusiasts, In this recent thread, the topic of muting the system sounds came up ... With the advent of Windows Vista, the mixer\sounds are per process and Winmm.lib legacy audio apis don't seem to be working for selectively controlling individual sound sessions. After some...

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...