It does work in Excel 2000. I just tried it today.

Ryan

"Myrna Larson" wrote:

It's a case of failing memory <g. What you describe has never worked in any
version of Excel that I've used. I've missed it, too.

On Fri, 25 Mar 2005 07:37:03 -0800, "
wrote:

in Excel 2000, using the GetOpenFileName method you can include a FileFilter
(the first argument) such as *.something.extension and the dialog box would
show those files.

Starting in Excel XP that does not work in code anymore. You can physically
type that into the dialog box under "File name" and it will work but when it
is set in code it will only recognize *.extension.

Is this a design change or a bug?

Sample code:
----------------
FileName = Application.GetOpenFilename("Sample Files (*.test.txt),
*.test.txt")
----------------
This will not show a file named First.test.txt in Excel XP/2003 but the same
code will show the file in Excel 2000.

Ryan