Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Try
Dim FName As Variant FName = Application.GetOpenFilename(filefilter:="All files (*.*),*.*") If FName = False Then MsgBox "you clicked cancel" Else MsgBox "You selected: " & FName End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message ups.com... Hello... I am trying to use some code by Chip Pearson to import text files. It works great, except the particular files that I must browse for have NO filename extension; therefore, they do not appear in the list when browsing for documents. The current code is as follows (and one would think that it would find anything): (filefilter:="Text Files(*.txt),*.txt,All Files (*.*),*.*") Does anyone know how I can modify this to find files with NO extension? Any help would be greatly appreciated. Thanks, Jessi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display file name without the file type extension | Excel Worksheet Functions | |||
need Excell to display something other than what I type | Excel Worksheet Functions | |||
macro to display items of a same type | Excel Programming | |||
Comment Shower type display | Excel Discussion (Misc queries) | |||
Type in textbox display immediately in cell - need help on this | Excel Programming |