M/S Excel possible problems with CommonDialog control

If the Excel application with macros (CreateChart.xlsm) won't open properly and reports various errors concerning the ComDlg32.ocx file the text below could solve the problems.

Begin by unzip the comdlg.zip file to your Desktop. The file is included in the MeasLog setup file and is located in the program folder
Or download it from here.

First make sure ComDlg32.ocx exists in your system. In a 64 bit Windows it should be in the c:\Windows\SysWOW64 folder and in a 32 bit
Windows in the c:\Windows\System32 folder.  Either check it manually or run the 64_exist_comdlg.cmd (or 32_exist_comdlg.cmd ) file as administrator.

If it doesn't exist either copy it manually from the unzipped file or run the 64_copy_comdlg.cmd (or 32_copy_comdlg.cmd) file as administrator.

To register the file you just copied run the 64_register_comdlg.cmd (or 32_register_comdlg.cmd) file as administrator.

Now open the Excel file (CreateChart.xlsm) with the errors.
With the main sheet open press Alt+F11.
Click the + next to Forms.
Double click on the OpenSaveDataForm.

  It should look like this:   

If the icon is there this application should now work but you probabaly won't be able to select and use the control on a new design in the future.

If the form is empty click on the Toolbox icon (crossed hammer and wrench) on the toolbar.
If the Common Dialog icon is missing from the Toolbox you just opened right click in a free space and select Additional Controls.
In the dropdown list tick the Microsoft Common Dialog Control and close Additional Commands.
The icon should now appear in the Toolbox.
>> Now click and drag it to the empty form.
If that worked with no error message your done and the application should now work.
Close the vba window and save the file.

Most likely there will also be an error message saying that the control isn't properly licensed.
If so, and to be able to use the control on new designs it must be licensed. Run the comdlg.reg file as administrator.
You can find info on the reg file in the pfd document included in the zip-file.
Goto >> above and do it and the next 2 lines and hopefully the problems will be solved.

Email me with comments. /Håkan