How can I capture folder directory names of excel files 1

[JRUKUSA]

I have a large volume of excel files stored in a folder, each file name relates to a project, I have a master list of project names. How can I copy the file names from the directory into an excel file such that I can then validate the files names against the project master list in excel.

Thanks in advance of any assistance.

JRUKUSA

 

[xlhelp]

With some difficulty.

Under Sart, Programs, Accessories, you should have "Command Prompt"

When you select this, you will get a blank screen.

Note the drive and path indicated.

type

dir (full path of directory you want) > list.txt

example:

dir C:\MyDocu~1\xlhelp > xlh.txt

for long folder names use first six characters and ~1

this will give you a text file that you can import into Excel

With litlle bit of practice you will be an expert.



Member AAA - Abolish Abused Abbreviations

 

[JRUKUSA]

Thanks for the quick response, I will give it a go, not sure about becoming an expert though!