Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Playing Music through Macro / VBA on mouse click

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  2. #2
    New Member
    Join Date
    May 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •