G
Guest
IS THERE ANYWAY TO COPY AND PASTE THE FILE NAMES FROM EXPLORER TO AN EXEL
FILE????
FILE????
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frankster
Wes said:IS THERE ANYWAY TO COPY AND PASTE THE FILE NAMES FROM EXPLORER TO AN EXEL
FILE????
YOU MIGHT WANT TO TRY THE COMMAND LINE BY TYPING DIR /W > MYDIR.TXT.
G
Gord Dibben
Wes
Turn off the CAPS please. Hard on the ears.
Several methods to accomplish this.......I like Tushar's best if importing to
Excel.
To add a "Print Directory" feature to Explorer, go to
this KB Article.
http://support.microsoft.com/default.aspx?scid=KB;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 Notepad or
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-ins>Directory
Listing.
Download the ZIP file and un-zip to your Office\Library folder.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
Turn off the CAPS please. Hard on the ears.
Several methods to accomplish this.......I like Tushar's best if importing to
Excel.
To add a "Print Directory" feature to Explorer, go to
this KB Article.
http://support.microsoft.com/default.aspx?scid=KB;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 Notepad or
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-ins>Directory
Listing.
Download the ZIP file and un-zip to your Office\Library folder.
Gord Dibben MS Excel MVP
IS THERE ANYWAY TO COPY AND PASTE THE FILE NAMES FROM EXPLORER TO AN EXEL
FILE????
Gord Dibben MS Excel MVP
D
Donald Lessau
Wes said:IS THERE ANYWAY TO COPY AND PASTE THE FILE NAMES FROM EXPLORER TO AN EXEL
FILE????
XYplorer (file manager) can export directory listings directly to *.csv
files.
Screenshot: http://www.xyplorer.com/shots.htm#reporttocsv
Don