Playing Music through Macro / VBA on mouse click

SubZero · May 7th, 2002, 05:29 AM

(cell coordinates used are irrelevant just examples)
I have a database that lists MP3 files. What I would like to do is play the MP3 file that each row represents. (example of row format . A1 = PC filename, A2 = title, A3 = artist and so on.)
I therefore need a macro that will use A1 as the name, locate that on the root E: and play it in excel, media player or winamp etc. I can add a column eg A2 could be PC path so that if A1 is simplythebest and A2 is
mp3turner the macro will load the MP3 file E:mp3turnersimplythebest.mp3
Now the next trick part is the list can get sorted by seperate macros by Artist, year & Title. If I use a picture or button in column I for each row these will not be sorted at the same time. So, can the macro be made to do the following. Only activate if the mouse is clicked on a cell in Column I. Then for example if I clicked on I23, it would take the information of the MP3 file from ROW 23, so forth and so on.
Many thanks, hoping someone can help!

SubZero · May 7th, 2002, 07:47 AM

I would still be ineterested if someone can do this with code, but realised I was just overcomplicating the issue! I have done it by simply hyperlinking to the relevant file (using concatenate etc and a simple macro)
didn't think of that for over a week! Doh!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 05:29 AM	#1
SubZero New Member Join Date: May 2002 Posts: 8	(cell coordinates used are irrelevant just examples) I have a database that lists MP3 files. What I would like to do is play the MP3 file that each row represents. (example of row format . A1 = PC filename, A2 = title, A3 = artist and so on.) I therefore need a macro that will use A1 as the name, locate that on the root E: and play it in excel, media player or winamp etc. I can add a column eg A2 could be PC path so that if A1 is simplythebest and A2 is mp3turner the macro will load the MP3 file E:mp3turnersimplythebest.mp3 Now the next trick part is the list can get sorted by seperate macros by Artist, year & Title. If I use a picture or button in column I for each row these will not be sorted at the same time. So, can the macro be made to do the following. Only activate if the mouse is clicked on a cell in Column I. Then for example if I clicked on I23, it would take the information of the MP3 file from ROW 23, so forth and so on. Many thanks, hoping someone can help!

May 7th, 2002, 07:47 AM	#2
SubZero New Member Join Date: May 2002 Posts: 8	I would still be ineterested if someone can do this with code, but realised I was just overcomplicating the issue! I have done it by simply hyperlinking to the relevant file (using concatenate etc and a simple macro) didn't think of that for over a week! Doh!