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
|
|||
|
|||
Screen print list of all files stored and not each individual file
Excel 2003 - After I select file, open, look-in, how do I print only the list
of all files stored without actually printing each individual file? I tried highlighting all files stored, right click print and nothing happened! |
#2
|
|||
|
|||
HarleyGirl,
Gord Dibben wrote a comprehensive reply to this some time ago, quoted below. HTH, Bernie MS Excel MVP Several methods to accomplish this....... 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. Gord Dibben Excel MVP "HarleyGirl" wrote in message ... Excel 2003 - After I select file, open, look-in, how do I print only the list of all files stored without actually printing each individual file? I tried highlighting all files stored, right click print and nothing happened! |
Thread Tools | |
Display Modes | |
|
|