| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba to get file extension from col A file names
Hi: Excel2003. I have a list of file names in column A (340 rows). I want to
copy the extension (only) from each name in col A to col B -- so I can sort the worksheet by file extension. There are about 15 extensions (.xls, .doc, ..lnk etc.) Can someone provide me the VBA code, or a starting point, to do this? TIA, Stephanie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
| file format or file extension is not valid...error message | Excel Discussion (Misc queries) | |||
| Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
| Saving two file names? One with no extension? | Excel Programming | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
Threaded Mode
