Play CD from Excel

[GoodmanJim]

I have a CD music database in Excel. This database finds the CD I am looking for and displays its cover. I would like to have a button on this worksheet to play the CD using Microsoft Media Player. This would require finding the file, opening it, selecting all mp3's and then opening Media player with those files.

Any help will be appreciated
Thank You

 

[ashakantasharma]

You can link the entire path of the mp3 files in excel which can create a link when cd is inserted and will be played on default media player in Windows