Writing each XL File Path found in a folder to An XL Sheet in separate cells:

[Asad Mir]

Hello Everyone!
The only thing i am unable to do here is somehow write those file paths found through running the following code in an excel sheet in separate cells, preferably using looping or any other simple method.

Any help would be greatly appreciated.
Thanks in advance.

Please Login or Register  to view this content.

[Andy Pope]

here is one way, start cell is A1 of activesheet

Please Login or Register  to view this content.

[Asad Mir]

Many Thanks Andy!!!