Filename extraction

[teel73]

Hi..can someone please help me with this.

I have a folder on my desktop named: [BFolder]. In this folder contains 100 files of .jpgs. I would like to extract the .jpg filenames into either a spreadsheet, txt file or table in a database. Is there a way I can do that?

 

[vbaInet]

Is it necessary to store the file names? What if the file names change?

 

[ghudson]

Did you try searching the forum? Browse [Find a directory or file]

 

[gemma-the-husky]

and certainly one solution will involve using the Dir function