<div>
If you use tree /a (A for ASCII) it will extract the folder structure.<br />
<br />
You coud try<br />
tree /a &gt;mytreetextfile.txt<br />
<br />
and then open the text flie in Excel.<br />
<br />
<br />

</div>


If you use tree /a (A for ASCII) it will extract the folder structure.

You coud try
tree /a >mytreetextfile.txt

and then open the text flie in Excel.




<div>
You could also use <br />
<br />
dir /b /ad /s<br />
<br />
/b - Bare. No headers etc<br />
/ad Attribute directory (That's what folders used to be called &nbsp;;-)<br />
<br />
/s Subdirectory<br />
<br />
Use<br />
dir /b /ad /s &gt;bigdirectorystructure.txt<wbr /> &nbsp;<br />
<br />
To capture the results.<br />
<br />

</div>


You could also use

dir /b /ad /s

/b - Bare. No headers etc
/ad Attribute directory (That's what folders used to be called  ;-)

/s Subdirectory

Use
dir /b /ad /s >bigdirectorystructure.txt  

To capture the results.



<div>
That's neat. :-)<br />
<br />
I still use the tricks I learned before I knew any VB. :-)<br />
<br />
The &quot;dir /b /ad /s &gt;&nbsp;folderstructure.txt&quot; from the command prompt gets the results that end up in col B.<br />
<br />
Cheers!<br />
<br />
TRM 
</div>


That's neat. :-)

I still use the tricks I learned before I knew any VB. :-)

The "dir /b /ad /s > folderstructure.txt" from the command prompt gets the results that end up in col B.

Cheers!

TRM

<div>
answer found on this site:<br />
<a href="http://www.mrexcel.com/forum/showthread.php?t=526340" rel="ugc">http://www.mrexcel.com/forum/showthread.php?t=526340</a>
</div>


answer found on this site:
http://www.mrexcel.com/forum/showthread.php?t=526340 [http://www.mrexcel.com/forum/showthread.php?t=526340]

<div>
Answer found on this site.<br />
<a href="http://www.mrexcel.com/forum/showthread.php?t=526340" rel="ugc">http://www.mrexcel.com/forum/showthread.php?t=526340</a>
</div>


Answer found on this site.
http://www.mrexcel.com/forum/showthread.php?t=526340 [http://www.mrexcel.com/forum/showthread.php?t=526340]

<div>
<div class="content wysiwyg-content">
I would like vb script / macro on exporting folder structure, including subfolders into an excel file. I do not necessarily need the folder names at this point. Just a file structure.
</div>
</div>


I would like vb script / macro on exporting folder structure, including subfolders into an excel file. I do not necessarily need the folder names at this point. Just a file structure.

how to export folder and subfolder structure into an excel spreadsheet

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

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.