To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
VBForums  

VB Wire News
Part 10 of the Visual Basic .NET 2010 Express Tutorial Complete!
How to Use the Visual Studio Code Analysis Tool FxCop
Article :: Interview with Andrei Alexandrescu (Part 3 of 3)
Introducing Visual Studio LightSwitch
Visual Studio LightSwitch Beta 1 is Available



Go Back   VBForums > Visual Basic > ASP, VB Script

Reply Post New Thread
 
Thread Tools Display Modes
Old Sep 15th, 2006, 08:43 AM   #1
moneyfool
New Member
 
Join Date: Sep 06
Posts: 3
moneyfool is an unknown quantity at this point (<10)
Getting DIR listing into Excel

How can I get dos directory listing into excel? If you do dir on dos command prompt you get


Directory of C:\Temp

07/18/2006 11:24a 13 Admin\ABC ToDo.xml
07/24/2006 01:14p 14 Admin\ABC codefrag.xml
09/13/2006 02:40p 59 Admin\ABC mylist2.txt

Directory of C:\Temp\Testing

08/17/2005 03:01p 17,408 Admin\ABC Building.xls

Is it possible to get the info into excel? If yes can you get it as

07/18/2006 11:24a 13 Admin\ABC ToDo.xml c:\temp
07/24/2006 01:14p 14 Admin\ABC codefrag.xml c:\temp
09/13/2006 02:40p 59 Admin\ABC mylist2.txt c:\temp
08/17/2005 03:01p 17,408 Admin\ABC Building.xls c:\temp\Testing


Thanks for help.
moneyfool is offline   Reply With Quote
Reply

Go Back   VBForums > Visual Basic > ASP, VB Script


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:10 AM.





Acceptable Use Policy

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.