View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Ryan@newsgroup.nospam is offline
external usenet poster
 
Posts: 3
Default GetOpenFileName method different in Excel

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