Playing Music through Macro / VBA on mouse click

SubZero

New Member
Joined
May 6, 2002
Messages
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!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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!
 
Upvote 0

Forum statistics

Threads
1,214,649
Messages
6,120,728
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top