Hi
I'm trying to use an Excel file to archive configs. So far I have
been able to find the files and input them into sheet1. with the 1st
code. However the file name entries have the file name's path
attached to the name. Is there a property option to only put the file
name in column 1?
Secon
e to get the third "word"?
> like: "file_For_Tommy.xls", "file For Tommy.txt", what delimits a "word"?
>
> Are you familiar with VBA?
> Have you started?
>
> I think I can throw something together quickly (10-15 minutes).
>
> Paul
>
Hi
Maybe I'm not using the right search terms, but I couldn't locate how
to import over 100 small files into Excel. Each file should get it's
own worksheet. And each worksheet should be name with the 3rd "word"
or character string in the file. In case someone is wondering, the
total number of
