Show file extensions in GetOpenFilename

[DennisE]

Excel Experts,

When I invoke GetOpenFilename from within Excel/VBA,
I would like to see displayed in the dialog box the file extensions
(e.g., not just TestCase.1 but TestCase.1.txt). I can do this before
calling Excel by bringing up Windows Explorer then selecting Tools,
then Folder Options, and unchecking "Hide extensions for known
file types." My question is, can this be done programmatically
through VBA (or equivalently by setting the appropriate parameters
or properties in GetOpenFileName) ?

-- Dennis Eisen

 

[Frank Kabel]

Hi Dennis
AFAIK this is a windows setting -> so you'll need the 'explorer way'
(or maybe - but not tried - using Windows API calls)