Home » Forums » Open Source Learning Center » Question and Answer

Mac-Folder & Subfolder List creation from a Hard Drive

Submitted by Jim99 on 12 January, 2012 - 09:15

Hi all
I have a external Hard Drive which i use to store all my Audiobooks. These Audiobooks are organised by Folders (Authors Name=First Name first then Last Name) and those Folders have subfolders where the various Book Titles are stored. ( I might also have in there a separate sub folder for a Series that that Author may have written) What i would like to, is make a list in excel showing me a list for all Authors and which book i have from these Authors. ( and if they have a Series what Titles i have in that Series)

i am not sure how ( actually i hav'nt got a clue!) to go about this, especially as it keeps changing after adding more Audiobooks to that Hard Drive- maybe there is a simple way to make this happen, i don't know- i am using an Apple iMac and am not familiar with using "Terminal" (do not have Windows-sorry)
Can somebody help me?

‹ Buy to let calculator Get a value from an other workbook with a path changing according a cell value ›
»
Nick's picture

hi Jim This will work on a PC

Submitted by Nick on 12 January, 2012 - 10:28.

hi Jim

This will work on a PC to list the files and folder paths:

RE MAC - Macs don't allow VBA code to run, so it's not possible.

Nick

 

»

Jim's Mac

Submitted by Jim99 on 12 January, 2012 - 11:00.

Thanks Nick

»

Mac & Excel Scribt running in VM mode-OK

Submitted by Jim99 on 13 January, 2012 - 04:14.

Hi Nick
OK, so i installed Parallels Desktop on my iMac and also MS Office 2007 Ultimate running all on Windows XP Pro.
To my own surprise i have managed to get some of the info from running your script file on my Audiobook Hard-drive which is mounted on my OX Lions Desktop.
There is a couple of things i don't know how fix.
when i run the script I get the list showing (under the Parent Folder) X:\Audiobooks\Aaron Ralston\Between a Rock and a Hard Place this is repeated several times for each mp3 file for that particular audiobook.
Question, is it possible to omit the X:\Audiobooks part and also only list it once, ( it currently list the same file several times for each mp3 for that file) i wonder if it can be made to look like this:
Aaron Ralston\Between a Rock and a Hard Place
Adriana Trigiani\Adriana Trigiani - Lucia
Adriana Trigiani\Adriana Trigiani - Viola In Reel Life 2009
Adriana Trigiani\Adriana Trigiani - Home to Big stone gap
Alastair Reynolds\Terminal World

Any help is apriciated Thanks

»
Nick's picture

Hi That's good news.. We have

Submitted by Nick on 13 January, 2012 - 08:08.

Hi
That's good news.. We have a tip on how to 'remove duplicates' on the website.. Type that into the search box

»