dlg macro not working on 2016

Hello,
first of all, I want to say hello to all the community.

I have a excel file that works without problems in excel 2010, is a special macro created by Siemens company, it generates a text file based on the excel file, but on excel 2016 not works:
1.- if a open the .xls [compatibility mode] file directly it shows that some objects can not be loaded due are not available on this equipment,
1.1.- I run the macro " menu_on" , it adds a new "SIMATIC" tab
1.2 in Add-ins SIMATIC ribbon I click on SIMATIC->save DB as AWL -file
1.3 appears an error of compilation indicatins that it is not found the method or data member
1.3 it highlights dlg.dlgFinDBFile.ShowSave


2.- I save it in .xlsm, close and open it again
2.1 now it is don't showed the error of the unfound objects
2.2 when click on Add-ins SIMATIC ribbon I click on SIMATIC->save DB as AWL -file
2.3 appears an error of compilation indicatins that it is not found the method or data member
2.4 it highlights dlg.dlgFinDBFile.ShowSave


Please, can someone bring light of hoe make it works in excel 2016, I tried to install framework 4.6.2, and other tools I see recommended ,but without exit.

Thanks in advance to all the community.

Originally Posted by buran

It looks like you a missing some external library. in VBA editor go to Tools->References and check if you have any missing references (i.e. it will have MISSING) in front of it. In other words it's not 2010/2016 compatibility issue, but simply you a missing some software that has to be installed before you can use the Siemens macro

Thanks for the quick reply, I am using two separated laptops,

in the laptop with 2010 shows in References:
·Visual basic for applications
·Microsoft excel 14.0 object library
·Microsoft forms 2.0 object library
·Microsoft office 14.0 object library
·Microsoft common dialog control 6.0 (sp6)

in the laptop with 2016 shows in References:
·Visual basic for applications
·Microsoft excel 16.0 object library
·Microsoft forms 2.0 object library
·Microsoft office 16.0 object library
·Microsoft common dialog control 6.0 (sp6)

the rest are unmake, I don't see MISSING anywhere

Also, I forgot the excel file, hahaha,
please, find attached the excel document if you are interested to test

Thanks again...

Originally Posted by buran

I'm sure the problem is with missing or not properly installed Microsoft Dialog Control. You too said that some objects can not be loaded due are not available on this equipment.
the problem is with controls on dlgFile UserForm and I've got the same warning and here is how my references window looks like:

Attachment 482622

on your laptop check the location of the control and confirm that you actually have the file (for example if somehow the file was deleted by mistake and the registry key is still there)

Thanks again for your help, but before Microsoft common dialog control 6.0 (sp6), it is not showed the word MISSING, the file exist on laptop with date 09/03/2004

.....

I think I am stuck with this...