dispcallfunc

  1. Jaafar Tribak

    Reading and Editing Metadata File Properties.

    Hi, I was spurred to explore this subject further after this recent thread As far as I can see, there seems to be no easy way to edit file properties programmatically without needing to resort to external components such as CDDBControl.dll or CDDBControlRoxio.dll (which by the way these two...
  2. D

    DispCallFunc - 64bit VBA

    WIth the help of Jaafar, I'm trying to learn how to use the DispCallFunc API with 64 bit API. I have been trying to work my way through the examples at the following tutorial: Windows API DispCallFunc as function pointer in VBA And managed to get the following working: Private Declare PtrSafe...
  3. Jaafar Tribak

    Getting the list of all Enums in TypeLibs via code (Like the Object Browser)

    Hi all, This is a similar concept to the topic of this thread. Only this time, instead of retrieving Properties and Methods of Objects, the code now retrieves the names and values of all the native ENUM constants contained in typelibs. No extrenal libraries required. the functions in the code...
  4. 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...
  5. Jaafar Tribak

    Reference and remotely manipulate UserForms loaded in seperate workbooks or in seperate Excel Instances via File Monikers.

    Hi, this an continuation of some code I posted in the past see Here ... This new addition uses file monikers to register objects in the Running Object Table and hence makes it possible to access UserForms from remote processes via the standard GetObject vba function. The advantage of using...
  6. Jaafar Tribak

    (FindExecutable) - (AssocQueryString) - (IAssocHandler Interface)

    In an attempt to answer this question and aftter searching this subject in the last few days, I found that the FindExecutable API function doesn't always work for finding the (.exe) associated with a specific document file. This API function works consistently when applied to some file...
  7. Jaafar Tribak

    Drag and Drop Shell Thumbnails onto the Worksheet as Shapes

    Hi, As the title suggests, the code allows you to drag thumbnails from explorer onto the activesheet and automatically converts them to excel Shapes. I've written and tested the code in Excel 2016 x64bit so I would love to know if it works in other versions as well.. If any of you tries the...
  8. 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...
  9. Jaafar Tribak

    Get list of all Properties and Methods for an object with VBA code alone

    Hi dear forum, Workbook Sample I am posting here a self-contained vba approach for getting members of an object without the need for an external dll such as the well known TLBNINF32.DLL . The GetObjectFunctions function takes two arguments : (1) The object being browsed and (2) an optional...
  10. Jaafar Tribak

    Extract Thumbnail preview from file

    Hi all, workbook example Extracting a thumbnail from a file (thumbnail as shown in windows file explorer) normally requires the use of a typelib but with the assistance of the handy DispCallFunc API function, one can execute a requested interface Method w/o the need of an external typelib...

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