Import name ONLY of a (.tif) file

[dmeid]

I have MANY scanned image (.tif) files in multiple folders based on certain criteria. I need to find a way to import only the names of these (.tif) files into a table or even into an excel spreadsheet. Since they are scanned images you can not do a simple copy / paste.

I would appreciate if anyone has any ideas how this could be mastered

 

[FoFa]

Do you just want the file names, or the actual .TIF file imported?

 

[dmeid]

Really what I need is the full path of the .tif ...... but if I can not seem to retrieve that, all I need is only the name of the file not the image itself.

 

[FoFa]

If it is a one time thing, you can dump a directory list out and import it with a small amount of modifications.
If how ever it is dynamic, then you are best off using the FileSystemObject to process the file tree and obtain the information programatically.

 

[dmeid]

Thanks so Much FoFa. My train of thinking wasn't going in that direction. That will work out great.