GetFiles.xls

<div>
If you have 10,000+ files in each of the 40 folders, then, you must use Excel 2007 to get all the data into one column because Excel 2003 has a limit of +/- 65,000 rows. This is something that you have to be aware...<br />
<br />
jppinto
</div>


If you have 10,000+ files in each of the 40 folders, then, you must use Excel 2007 to get all the data into one column because Excel 2003 has a limit of +/- 65,000 rows. This is something that you have to be aware...

jppinto

<div>
Thank you Albert and Dave<br />
Both work perfect. but alberts script as it records other info is slower than Dave's provided script. but both work.. :-)
</div>


Thank you Albert and Dave
Both work perfect. but alberts script as it records other info is slower than Dave's provided script. but both work.. :-)

<div>
Thanks for points and the grade!<br />
<br />
:-)<br />
Albert<br />

</div>


Thanks for points and the grade!

:-)
Albert


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Get all the txt file names into a excel from the path mentioned with all sub folders too.<br />
<br />
D:\Software<br />
In the path i have 40 + folders and each folder has 10000's of files. Need to get all txt files into a &nbsp;colum in an excel.<br />
<br />
regards<br />
sharath
</div>
</div>


Hi,

Get all the txt file names into a excel from the path mentioned with all sub folders too.

D:\Software
In the path i have 40 + folders and each folder has 10000's of files. Need to get all txt files into a  colum in an excel.

regards
sharath

Get all the txt file names into a excel from the path mentioned with all sub folders too.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.