Thread: vba to get file extension from col A file names
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
StephCA StephCA is offline
external usenet poster
  
Posts: 3
Default 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

Reply With QuoteReply With Quote