Replacement for Visual Basic Object "CommonDialog"

[kato01]

Hello,

I have some old visual basic macros I am trying to convert to excel VBA.

I am not sure what to do about the CommonDialog object. Searching online, I found that it’s obsolete and replaced by something else. Couldn’t find by what.

Any suggestions



Thanks

 

[Dan_W]

Hi. Converting VB6 code and older (32 bit) VBA code to (64 bit) VBA seems to have become a bit of a hobby for me, so your question re the common dialog control certainly resonates.

The common dialog control is broadly obsolete for those using VBA today, because much of its functionality had been abstracted away for us. Basically, it was a way to call certain system dialog boxes: (1) Open File Dialog; (2) Save File Dialog; (3) the Colour Picker Dialog; (4) the Font Chooser Dialog; (5) the Printer Dialog and, off the top of my head, maybe one or two others.

In terms of your conversion of your older code to something usable today, it'll depend on which of the above you're trying to use.

I think that there are class modules that you could import into your project that might effectively work as a drop-in replacement for the control, and therefore help avoid having to change any of your code, but it shouldn't really be that difficult to update your code.