Search all the paths...

[sn152]

Hi All,

I am trying to get the contents of multiple folders in an excel sheet. Contents in the sense File name, type, created date, modified date, last accessed date etc.

But each and every folders have different paths. My macro has to check all these paths and update the required details in the "Output" sheet.

I have used a code which will check only one single path. And that too this is very slow as the folder that I check is in a server. So it is taking too long for this code to search one folder.

Can you please help me with a sample for this.

Thanks in advance!

 

[NARAYANK991]

Hi ,

You can find enough samples on the Internet ; search for :

VBA recursive path folder

the significant word being recursion or recursive.

See the following link for one sample code :

http://www.codeproject.com/Questions/549737/RecursiveplusDirectoryplusListingspluswithplusVBA

Narayan

 

[sn152]

Hi Narayan,

Thanks for replying.

I checked this. The code which I have used in this excel file is the one which i got from internet. But it checks only one particular path that is specified in the code.
But I want to check multiple paths (around 65 paths). Please help me with this.

Another thing is, this code which I have used is very slow as the path specified is a server path. Please help me.

Thanks!

 

[NARAYANK991]

Hi ,

Please wait for a day or two ; help will come.

Narayan

 

[sn152]

Okay Thank you

 

[sn152]

Hi All,

Any update on this?

Thanks!

 

[sn152]

I figured this out. Thanks!