| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine File Type
Is there a way to determine a file type or format(such as
CSV, TXT, etc) BEFORE VBA opens the file? I have VBA code with dialog boxes that prompts a user to select a .txt file, then open and process it. I have restricted the display in the file open dialog box to only show .txt files. However, we all know that a file could be something other than .txt even though it has that extension... Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
| when inserting a file name in a cell how do you remove file type | Excel Worksheet Functions | |||
| How do I change file/open/"files of type" to default to "all file. | Excel Discussion (Misc queries) | |||
![Brent[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
