Post by Alrik on Jan 20, 2008 21:12:53 GMT
Hello, everyone.
A German computing magazine (which I regularly read since around 2000) published in 2002 a small series of articles on how to make a spreadsheet which lists all of your music-CDs.
I've been digging this out recently, and want to present it to you, because I don't know any better way of having a database which lists all of your music-CDs.
The point here is that this MS Office VBA-based database spreadsheet reads the music-CDs automatically and recognizes them via connecting to FreeDB, the almighty music-CD database.
You can find the stuff here: ftp.heise.de/pub/ct/listings/0216-172.zip
It includes a small program that installs an Activex-component the author of this series of articles had developed then.
It also includes two templates: One for MS Word, and one for MS Excel. Remember that the series of articles (3 or 4 in fact) were written in 2002. So, this is for MS Office 2000 or later.
This ftp.heise.de/pub/ct/listings/0214-184.zip contains a version for MS Office 1997.
There is or should be little German text you should know or be able to read.
First, the readme file says, you have to copy the template files (.xlt , .dot) and the tiny .BMP pictures to your personal (or "all users", that's what I did) MS Office template directory.
You use it by starting (opening) a "new document" - I've tried it so far only with Exel - and chosing the template of this small package.
You must allow the macros in this template / new document in order to get it running properly.
It will then ask you for a (your) valid e-mail adress which is used to contact FreeDB.
Then, you can see somewhere a few tiny, very tiny buttons labelled with the letters of your drives.
You just insert a music-CD and press the tiny button with the letter of the appropriate drive.
The rest should be done automatically - but I honestly don't know whether it will run on non-German versions of MS Office.
I'd like to hear from you whether this runs, but I really can't say whether I'll be able to help you, because I didn't even look into the sourcecode yet.
And - if you know a better "self-detecting" database program for music CDs (I used iTunes and the Magix MUsic Manger before that), please inform me of it.
Alrik
A German computing magazine (which I regularly read since around 2000) published in 2002 a small series of articles on how to make a spreadsheet which lists all of your music-CDs.
I've been digging this out recently, and want to present it to you, because I don't know any better way of having a database which lists all of your music-CDs.
The point here is that this MS Office VBA-based database spreadsheet reads the music-CDs automatically and recognizes them via connecting to FreeDB, the almighty music-CD database.
You can find the stuff here: ftp.heise.de/pub/ct/listings/0216-172.zip
It includes a small program that installs an Activex-component the author of this series of articles had developed then.
It also includes two templates: One for MS Word, and one for MS Excel. Remember that the series of articles (3 or 4 in fact) were written in 2002. So, this is for MS Office 2000 or later.
This ftp.heise.de/pub/ct/listings/0214-184.zip contains a version for MS Office 1997.
There is or should be little German text you should know or be able to read.
First, the readme file says, you have to copy the template files (.xlt , .dot) and the tiny .BMP pictures to your personal (or "all users", that's what I did) MS Office template directory.
You use it by starting (opening) a "new document" - I've tried it so far only with Exel - and chosing the template of this small package.
You must allow the macros in this template / new document in order to get it running properly.
It will then ask you for a (your) valid e-mail adress which is used to contact FreeDB.
Then, you can see somewhere a few tiny, very tiny buttons labelled with the letters of your drives.
You just insert a music-CD and press the tiny button with the letter of the appropriate drive.
The rest should be done automatically - but I honestly don't know whether it will run on non-German versions of MS Office.
I'd like to hear from you whether this runs, but I really can't say whether I'll be able to help you, because I didn't even look into the sourcecode yet.
And - if you know a better "self-detecting" database program for music CDs (I used iTunes and the Magix MUsic Manger before that), please inform me of it.
Alrik