(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!
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!