Is there an API around that will allow me to read track titles via VBA directly off of a CD drive? There are some references to such ideas via Google, but some of the referenced URLs no longer exist or don't address the question.
Is there an API around that will allow me to read track titles via VBA directly off of a CD drive? There are some references to such ideas via Google, but some of the referenced URLs no longer exist or don't address the question.
I found this and tested 4 links in it and stopped there. You want to read sound file metadata, yes? Did you search on that?
https://social.msdn.microsoft.com/Fo...orum=accessdev
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Programs out there to read track titles and artist
Returns output like
CDTEXT STARTS
Title 0 Colorado
Title 1 Think Of Me - Neil Young with Crazy Horse
Title 2 She Showed Me Love - Neil Young with Crazy Horse
Title 3 Olden Days - Neil Young with Crazy Horse
Title 4 Help Me Lose My Mind - Neil Young with Crazy Horse
Title 5 Green Is Blue - Neil Young with Crazy Horse
Title 6 Shut It Down - Neil Young with Crazy Horse
Title 7 Milky Way - Neil Young with Crazy Horse
Title 8 Eternity - Neil Young with Crazy Horse
Title 9 Rainbow Of Colors - Neil Young with Crazy Horse
Title 10 I Do - Neil Young with Crazy Horse
Artist 0 Neil Young with Crazy Horse
CDTEXT ENDS
is that any good to you?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Yes, I could make that work for me if I'm reading directly off the CD. Essentially, I want to put a CD in an optical drive and run VBA code that will return the title of each track. Is such a program available? If so, is there an API I can obtain giving me VBA access?
Yes, and after some expired URLs and one down the Excel rabbit hole I moved on.
Well that program I searched for, downloaded and ran as a test will provide that output.? You supply the dive letter plus a parameter. I would write the output to a text file, then read that file.
You then need to process that output to get the titles and artist from that output.?
Are you prepared to do that, or do you want an easier solution?
There might well be one, but you need to search more?
Eg, this is for a Various Artists CD
CDTEXT STARTS
CDTEXT ENDS
so nothing produced, despite their being 18 tracks on the CD? The isrc parameter also shows no data?, so a bit hit and miss really?
In fact after a little further testing, I would not bother with this program?
I put another Neil Young CD in and it produced no data.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Yes, and after some expired URLs and one down the Excel rabbit hole I moved on.
Have a look at this link, as it could clear up a lot pertaining to CD-Text versus Metadata. With the age and mix of what I have, I think it would be more-or-less a waste of everyone's time to pursue this OP any further. Probably also answers why you had mixed results with "CDTEXT".
https://theproaudiofiles.com/cd-text-metadata-artwork/
I don't get what the issue would be about code being on an Excel site. It's the same VBA regardless as far as getting at the info is concerned.
I used the Excel code from the 6th link and got a spreadsheet with what looks like the track titles for every mp3 file in a folder, plus a lot of other tag info. If the code can do that, it can be modified to retrieve only the title and do whatever you want with it.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
@Micron,I don't get what the issue would be about code being on an Excel site. It's the same VBA regardless as far as getting at the info is concerned.
I used the Excel code from the 6th link and got a spreadsheet with what looks like the track titles for every mp3 file in a folder, plus a lot of other tag info. If the code can do that, it can be modified to retrieve only the title and do whatever you want with it.
The O/P specifically wanted direct from the cda files on the CD though?
Mp3 data is easy to come by in comparison.? I am sure isladogs posted something that read the all the file properties.?
I think the problem is, not all CDs have CDtext data. I tried two others and nothing was returned.?
I ripped my CD collection to mp3 many years ago, when we were still on dial up.
Took a while, but I was out of work, so what the hell
Nowadays it is so much easier.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
My Extended File Properties database does indeed get file properties but it won't help in this case as CD tracks are just saved as Track01.cda etc.
As already stated you need to rip the CD to extract the tracks in another suitable format such as MP3 or FLAC etc
There are numerous apps that do this and grab the artist & title info once extracted.
Once that is done, the file properties app will give you what you want
NOTE:
As a partial work round, You could easily add .cda files to the list of file types in the Media Player app I uploaded before.
Code:.Filters.Add "Media Files", "*.cda, *.wmv,*.mp4,*.mp3,*.doc, *.docx, *.xls, *.xlsx, *.pdf"
Once uploaded you can rename them manually
@isladogs
I found a program that would extract CDText as shown above. However if the CD has no CDText, nothing to retrieve?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I guess I was thinking of burned CD's that contained actual sound files. Sorry @GraeagleBill.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Colin, if I'm understanding you, maybe there's hope yet. What is actually happening here is that I'm in the process of loading my entire CD library into an NAS from which I can play either via my Cataloging app or the PLEX media server on our TV. Since I'm used to using Sound Forge (I've transferred a boat-load of 12" vinyl treating them like master copies over the years) I load in the CD's "track-at-a-time) and save as mp3 files. Your post suggests to me that unbeknown to me that the file properties of those mp3 files include titles? If that's the case, my cataloging app will take care of the issue with a few lines of code.
Not out of work, but retired long ago.......... same difference