file name and location export

[22strider]

Hello Friends

I am using Window XP and need to export file names to a text file.

For my project I need to export names of all the files along with their paths. I need to able to get names of all the files in all the subfolders (sub directories) under a folder along with their paths.

Thanks for your time

 

[Derek Brown]

Does this help:
http://www.mrexcel.com/forum/showthread.php?t=82047

 

[22strider]

Hello Derek

Thanks for your message.

I tried the code given on this link on VBA in Excel 2007; and got error that the object "With Application.FileSearch" is not supported.

Do you have any suggestions for making it work for Excel 2007?

One more thing; I also need to search the sub folders. For that I changed ".SearchSubFolders" to "True".

It seems like this should work but unfortunately the code is not for 2007.

Please let me know if you could modify it.

Thanks
Rajesh

 

[Derek Brown]

Sorry, I didn't know which version it was designed for.
Try:
http://excelexperts.com/VBA-Tips-List-Files-In-A-Folder
It gives and example using the Scripting.FileSystemObject that makes a recursive call (that is, to itself) to list sub-folders.

 

[22strider]

Hello Derek

I tried that code and am getting "User Defined Type not defined error". I see that somebody else had that problem and someone even provided solution. I still cannot make it work. Feeling pretty dumb at this moment.

Could you please have another look?

Thanks
Rajesh

 

[Derek Brown]

You need to set a reference (Tools | References) to:
Microsoft Scripting Runtime
You do that in the VBE Environment (where you created the VBA code).
Once you have done that, do "Debug | Compile VBAProject" and check that it compiles OK.