GetOpenFileName method different in Excel xp/2003 from Excel 2000.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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:
 
I have never tried it, but I wouldn't expect that to work in any version of
excel. If it does, then I guess that is a happy dance. the only thing
stated to work it so limit files based on the extension.

In xl2002 and later you could use the filedialog object to do what you
describe I would think.
 
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.
 
Back
Top