cocreateinstance

  1. Jaafar Tribak

    Capturing the Paste Event (API Hooking - Redirection)

    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...
  2. Jaafar Tribak

    Excel Screen Reader Upon Navigating With The Mouse (with VBA alone)

    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...
  3. Jaafar Tribak

    Display Userform in TaskBar with custom Icon and Hide Excel (mimicking a standalone application)

    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...
  4. Jaafar Tribak

    How to Automate a second instance of Excel via the IDispatch Interface .

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top