how can I add CommonDialog component in VBA development

[ken]

Hi All,
I use window98 / XP develop outllokXP VBA programmming, and I found if I
havnt install VB or VS in the same computer, I can not refer the component
CommonDialog when I code VBA origrams. Any one should give me idea how to
solve it?

thx

 

[Markus Hedwig]

CommonDialog is a collection of a few helpfull forms in VB.

To use it on non-VB Studio systems you need to copy the comdlg32.ocx from
your system32 directory and add it to to the system32 directory of the
'target-computer' then change to the commandline and switch to system32
directory and type regsvr32 comdlg32.dll
The CMD is now registered and can be used from any programm-.

This works for all NT based operationing systems for older os copy the file
to the system directory. The command to register the comdlg32.dll might be
slightly different.

 

[ken]

when I try to run regsvr32 in WinXP pro, it prompt "DllRegisterServer not
found".
what should i do?

thank you for your reply

 

[Markus Hedwig]

I just tried in the system32 path the command regsvr32.dll comdlg32.ocx an
dit works fine. It is possible you need another file in the system32
directory called. There is a file called comdlg32.dll + another few files.
Maybe it works if you copy this files to.