Coding a MACRO to list document name and file path

Hi,

I am a mechanical engineer with reasonable excel skills, but no experience in using MACRO. My task is to create a list of all the documents my company has created from the file directories we have stored on the network. Obviously these documents are split up into a number of sub folders, eventually leading to the required document. To do this manually I would locate the document in the lowest level file path, copy and paste the name of the file, copy this into cell A1, and than copy and paste the file path into cell B2.

I have created a MACRO that will do this for this simple example. What I want it to do is to repeatedly go through each folder to the lowest file location and list the name of the document and the file path for every single document.

I realise that I need some sort of repeat function coded, but other than that I am pretty much at a loss. Does anyone know whether this can be done and if so how?

Thank you for your time and I apologise in advance for my ignorance!

Will

Hi will

I have a program that will list all files in a folder including its sub folders.

It then does a lot more with those files but I will strip out the rest of the macro.

just drop the file into the folder you are interested in. It could be your c drive for example and open it.

It will run automatically and list all files in their folders.

Mem

Thank you very much, your solution is perfect! I have one question, the company I work for are often very panicky about security. Is there away I can check the macro coding to prove that it isn't a security threat (i realise it wont be!)?

Many thanks,

Will

just open it and read it.

click on developer.

then macro

select the macro

and click edit

you can read and amend it.