Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Music List
Hi All i was wondering if someone could please help me with a small query that I have. In one of my folders, i have a lot of music files. Is it possible to put together a list of the music that i have, without actually having a music file in the list. Any help would be muchly appreciated Mark -- sparky3883 ------------------------------------------------------------------------ sparky3883's Profile: http://www.excelforum.com/member.php...fo&userid=6893 View this thread: http://www.excelforum.com/showthread...hreadid=487751 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Music List
Mark
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 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 Excel MVP On Wed, 23 Nov 2005 13:45:09 -0600, sparky3883 wrote: Hi All i was wondering if someone could please help me with a small query that I have. In one of my folders, i have a lot of music files. Is it possible to put together a list of the music that i have, without actually having a music file in the list. Any help would be muchly appreciated Mark |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Music List
Hi Gord Thanks for your help. I tries your recommended way, but it didn't print off what I wanted. However, whenever I now double click to open a folder, Windows Explorer comes up instead. When i right click on the folder, Explore is set as default and not Open. Is this a result of me adding the Print Listing Function? Do you happen to know how I can change it back so that Open is set as default and when I doulbe click, it opens up the folder? Many thanks in advance for your help Mark -- sparky3883 ------------------------------------------------------------------------ sparky3883's Profile: http://www.excelforum.com/member.php...fo&userid=6893 View this thread: http://www.excelforum.com/showthread...hreadid=487751 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Music List
sparky
I showed you 4 methods Which did you use. I would assume the "Print Directory" method. You obviously missed a step or misstepped a step if you didn't get what you wanted. I have never had any setting for double-click on a folder that didn't open that folder in Windows Explorer. What did a double-click do for you prior to adding the Print Directory command? In order to add the Print Directory command to your right-click menu, you had to go into ToolsFolder OptionsFile Types and make changes there. Backtrack your steps to see what you missed. Gord Dibben Excel MVP On Mon, 28 Nov 2005 13:34:35 -0600, sparky3883 wrote: Hi Gord Thanks for your help. I tries your recommended way, but it didn't print off what I wanted. However, whenever I now double click to open a folder, Windows Explorer comes up instead. When i right click on the folder, Explore is set as default and not Open. Is this a result of me adding the Print Listing Function? Do you happen to know how I can change it back so that Open is set as default and when I doulbe click, it opens up the folder? Many thanks in advance for your help Mark |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Music List
Not true.
Folders double-clicked do not open in Windows Explorer, they open in their own window. Sorry about that mis-direction. Gord Dibben On Mon, 28 Nov 2005 13:59:11 -0800, Gord Dibben <gorddibbATshawDOTca wrote: I have never had any setting for double-click on a folder that didn't open that folder in Windows Explorer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List box setup, placement, and functionality | New Users to Excel | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |