Can I export files name from Explorer into Excel
 

--
JerryG

Can I export files name from Explorer into Excel
 

You need to write a macro. You have a number of ways to do this with a macro

1) You have the option of opending a File dialog to let you select a folder
then return all file names in the folder. You can include any inforation
from the files such as size of lat modified date.

2) You can do the same thing as 1 above but make the folder name fied.

3) You can open a file dialog with multiselect option set true and then let
the user select all the files they want returned.. Again you can return size
and last modified date.

"JerryG" wrote:


--
JerryG

Can I export files name from Explorer into Excel
 

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...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-insDirectory
Listing.

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


Gord Dibben MS Excel MVP

On Sat, 20 Jun 2009 11:09:01 -0700, JerryG
wrote:

Can I export files name from Explorer into Excel
 

Thank you both, I am trying to create indexes of large directories for Audits
and I was going to have to type them. Appreciate the help
--
JerryG


"Gord Dibben" wrote:

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...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-insDirectory
Listing.

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


Gord Dibben MS Excel MVP

On Sat, 20 Jun 2009 11:09:01 -0700, JerryG
wrote: