dir all files in a folder and sub folders

**Pero** · 09-08-2009, 06:36 PM

Hi.

Trying to write a macro that will dirr a files in a selected folder and write all filenames in a list.

Have completed a macro that will dirr all files from ONE map but it doesn't write the names of files in the subfolders under the selected map.

The code so far is :

Please Login or Register  to view this content.

Would be really greatful if someone could help me with a code that would dir all files in the selected dir + all files in dirs under that one !

Thanks in advance !

//

Per

**Leith Ross** · 09-08-2009, 06:58 PM

Hello Pero,

This macro will list either all the files in single directory or list all files in the directory and the subfolders. In columns "A - F" the following file information is listed: Name, Path, Size, Date Created, Date Last Modified, File Owner. You can change thor delete these as needed.

Please Login or Register  to view this content.

Example

Please Login or Register  to view this content.

**Pero** · 09-08-2009, 07:24 PM

Thank you for the quick response !

Tho I can't get it work.

When I copy this text into a module its not shown as a macro in the macro list.

What could be wrong ??

Thanks !

**Leith Ross** · 09-08-2009, 10:35 PM

Hello Pero,

You didn't do anything wrong. Any Sub or Function that takes arguments is automatically hidden from the macro list by Excel. Here is a macro that will be visible. Change the path to the one you want.

Please Login or Register  to view this content.

**Pero** · 09-09-2009, 09:26 AM

Thanks again for the help !

The macro is now visible in the macro list but now when i try to run the macro it says "Sub or function could not be defined"
And the text marked yellow text is:

Please Login or Register  to view this content.

I also want the macro to start at J13 to O13 instead of A:F.
Also I want the filepath be be a variabel that is red from the column C3.

Sry for my lack of knowlage in this matter, I'm trying to learn.

Many many thanks !

My code right now is:

Please Login or Register  to view this content.

Thanks in advance !

// Per

**Jubinell** · 09-19-2009, 10:36 AM

Hi,

I think the poster forgot to post the codes for the Get Owner macro.

You can find it here:

http://www.excelforum.com/excel-prog...in-folder.html

**Leith Ross** · 09-19-2009, 12:28 PM

Hello Pero and Jubinell,

Excellent catch on the missing macro Jubinell! I wrote the code and completely missed the obvious. Here is the full code with the corrections.

Calling Macro

Please Login or Register  to view this content.

List Files In Folder Macro

Please Login or Register  to view this content.

Get File Owner Macro

Please Login or Register  to view this content.

dir all files in a folder and sub folders

LinkBack

Thread Tools

Rate This Thread

Display

dir all files in a folder and sub folders

re: dir all files in a folder and sub folders

re: dir all files in a folder and sub folders

re: dir all files in a folder and sub folders

Re: dir all files in a folder and sub folders

Re: dir all files in a folder and sub folders

Re: dir all files in a folder and sub folders

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions