Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Gord Dibben
 
Posts: n/a
Default How do I import a Windows Explorer list into Excel?

Fred

Several methods to accomplish this.......I like Tushar's best.

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Excel.

One more method if you want to by-pass the *.TXT file and pull directly to
Excel is to use Tushar Mehta's Excel Add-in. This allows filtering and
sorting once you have the data in Excel.

http://www.tushar-mehta.com/ scroll down to Add-insDirectory Listing.

Download the ZIP file and un-zip to your Office\Library folder.

As to the second part of mission........the updating part......I think you
would just have to re-import all filenames again from the folder.

Gord Dibben Excel MVP

On 1 Dec 2004 11:11:29 GMT, fred wrote:

Is it possible to import the list of files one sees in Windows Explorer
into an Excel spreadsheet? (I have WinXP and Office 2003)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I import a windows explorer list of files into an Excel sprea. skeliher Excel Discussion (Misc queries) 2 December 1st 04 10:24 PM
how do i import a picture or drawing into an excel spreadsheet? ucastores Excel Discussion (Misc queries) 6 December 1st 04 05:40 AM
import Lotus file to Excel Lotus to Excel HELP! Excel Discussion (Misc queries) 2 November 28th 04 04:26 PM
How do I import data from a SECURED website into Excel? Jimmy Lam Excel Discussion (Misc queries) 0 November 27th 04 04:12 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"