FileDialog Properties

**jlt199** · 05-07-2010, 05:58 PM

Hi again,

I have another question!

I have written this function to open a dialog box to allow the user to select the text file to read

Please Login or Register  to view this content.

which works fine. My question is, how can I update this function to also allow files without extensions to be shown?

The researcher who will be applying my macro usually forgets to save the data in a .txt file and instead leaves them without extensions.

I'm currently running the function without the line

Please Login or Register  to view this content.

which shows all files, but if the folder in question contains a lot of other files this seems needlessly messy.

Many thanks

**JBeaucaire** · 05-07-2010, 06:30 PM

Change the filter from "*.txt" to "*.*"

**jlt199** · 05-07-2010, 06:33 PM

Thanks for your reply, but that will give me all files in the folder.

I'm looking to only see files with a .txt extension or without any extension at all. Meaning that all others, such as .doc or .xls are not shown.

**JBeaucaire** · 05-07-2010, 06:41 PM

Actually, if you do this, you can keep the txt default, and give yourself an "All Files" option in the File Type drop window:

Please Login or Register  to view this content.

**JBeaucaire** · 05-07-2010, 06:41 PM

Originally Posted by jlt199

I'm looking to only see files with a .txt extension or without any extension at all

I really don't think that creature exists. The option above is the best fall back I can think of.

**jlt199** · 05-07-2010, 06:49 PM

That's a shame, thanks for your help

**broro183** · 05-08-2010, 12:33 PM

hi,

I think the same as JB - that there probably is no creature like this. An alternative may (?) be to loop through each file & only Add it to the list if there is no "." in the filename string. Or create a list box which opens instead of the standard dialog box that is also populated by looping. I'm just guessing as I haven't tested either of these approaches.

Here's another guess... Could you eradicate the problem by asking your researcher to change their settings?
Ask them to open Windows Explorer - Tools - Options - View - Files & Folders, untick "hide extensions for known file types", then press [Apply to All Folders] & [ok].

I've been told this is good practice for the unrelated reason that some viruses etc duplicate file names & icons but can often be identified if the extension is shown b/c they will end in ".exe" (instead of the expected ".doc" or ".txt" etc).

hth
Rob

**JBeaucaire** · 06-16-2010, 07:20 PM

Hey, back again. From a suggestion given by someone on another forum, try this:

Please Login or Register  to view this content.

I've underlined the idea suggested, it sets the initial display to only show files with no extension at all.

**jlt199** · 06-16-2010, 07:41 PM

Thanks for your reply. If I edit my function to

Please Login or Register  to view this content.

Then is does indeed initially only show the files without an extension, but it then won't let me use the other filters to find the .txt files, or all files. Which ever option I select from the dropdown I can only see the files without an extension.

**JBeaucaire** · 06-17-2010, 02:53 AM

I can't speak to your version, but my version will show all the text files, as long as I press the DELETE key first to remove that default entry of "*." then the filters work again.