Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The getopenfilename function in Excel 97 says that:
Quoting the help system: fileToOpen = Application.GetOpenFilename("What Files (*.txt), *.txt") In Windows, this string consists of pairs of file filter strings followed by the MS-DOS wildcard file filter specification, with each part and each pair separated by commas. Each separate pair is listed in the Files of type drop-down list box. However, I've found that the filter is actually in the first part of the string. The (*.txt) immediately after the 'What Files' is what is actually used as the filter and the second *.txt does not seem to do anything at all! That is, if I change this to: fileToOpen = Application.GetOpenFilename("What Files (*.*), *.txt") I get all files listed; - the *.txt seems to do nothing. Is there something in this function that I'm missing? Thanks in advance, Tomcee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 with two windows in Windows 7 | Excel Discussion (Misc queries) | |||
i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
GetOpenFileName called from modal userform.. enables workbook windows. BUG? | Excel Programming | |||
GetOpenFileName method different in Excel | Excel Programming | |||
GetOpenFileName method different in Excel xp/2003 from Excel 2000. | Excel Programming |