How to export folder names through macro??

[Vipin Vijayan]

Hi

In one of my project, I need to update all the folder names (each folder name considering as a new project) in an excel sheet.

Is there any solution in macro to export all these folder names into an excel file????

Please advice??????

 

[Alexander Pils]

I have created two macros. first will list all the folders name and with the second one you can change it. I hope that's what you wanted.

 

[rumshar]

Hi

In one of my project, I need to update all the folder names (each folder name considering as a new project) in an excel sheet.

Is there any solution in macro to export all these folder names into an excel file????

Please advice??????

Hi,
Here is my version
With Regards
Rudra

 

[Vipin Vijayan]

Hi,
Here is my version
With Regards
Rudra

Hi Rudra,

Its simply perfect

Thank You very much......

 

[Vipin Vijayan]

Hi,
Here is my version
With Regards
Rudra

One more....

Can you please send me the macro to export "Date Modified" field also..

Vipin

 

[rumshar]

One more....

Can you please send me the macro to export "Date Modified" field also..

Vipin

Sure Vipin,
Here we go!
Along with Date modified I have included 'Date Created' also.Don't forget to let us know if it works for you.

With Regards
Rudra

 

[Vipin Vijayan]

Rudra,

Its working. Thank u so much.

Regards
Vipin