If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I export files name from Explorer into Excel
-- JerryG |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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: |
#4
|
|||
|
|||
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: |
Thread Tools | |
Display Modes | |
|
|