Folder option setting

hi

There is the following folder option(under folder options dialogbox) that is checked on some machines and on some machines it is not.

Hide extension for known file types

This is giving me grief because it is breaking code for some users when Vba does a workbook open on their machines


Is there a vba code that sets the folder option to checked for a number of folders and sub folders.

The code in that link doesn’t specify how to change the folder setting. I can use it to determine what the setting is. And it asks to use captions which I can’t use

You need to be a bit more creative.. you cannot control windows folderoptions but you can control how you code to open a workbook. So if the frontdoor is locked use the back door. Do not try to change the foldersetting, just detect the folder setting and for the setting that now is failing build a workaround to open the file without the extention.

Thanks. That does make sense. I am going to try that out