| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to select Excel files ONLY
My Function (below) is working fine -- I'm just using it by entering
=FileCount(Test) -- I see there are optional parameters to refine selection but don't understand what I am to enter.. What should I do in order to select ONLY *.xls files? TIA, Jim Only First three lines... Function FileCount(FolderName As String, _ Optional FileFilter As String = "*", Optional FileType As MsoFileType = msoFileTypeExcelWorkbooks) As Long With Application.FileSearch |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where does Excel2007 save files -- not where I select? | Excel Worksheet Functions | |||
| Select a file out of a list of files | Excel Programming | |||
| How do I set up a form to select files from | Excel Programming | |||
| Use Macro to Select All Files Within A Folder | Excel Programming | |||
| Select Text Files from Combobox | Excel Discussion (Misc queries) | |||
Threaded Mode
