Excel not cooperating

Hi, I have a variety of MP3, Wave, cwb (a Sonar program) professional background tracks.  I would like to create a play list of these songs in Excel.  Reason;  that gives me extra columns and can add such things as KEY, TEMPO, CAPO, etc. it would really be helpful to have everything display on one line when I play. So I went to a couple of songs and created a shortcut and attempted to put the shortcuts in Excel and it won't let me.  What I see is a bunch of jarbish (numbers and symbols) displayed all over Excel instead of just a SHORTCUT.  If I put the shortcut on my desktop or in my documents folder if pulls it right up but not in Excel. Here is a message I get from Excel when I try to do this.

Is there a setting in Excel that would allow me to do this?  Thanks for your help.
camtzAsked:
Who is Participating?
 
JohnBusiness Consultant (Owner)Commented:
The file you are trying to open (*.MP3) cannot be opened by Excel. It is not an allowed format. That is why it opens from a different application when you open it on the desktop. Excel won't do this.

You need to get one of the MP3 organizers that will let you catalogue MP3 files.
0
 
camtzAuthor Commented:
Sorry, forgot the pic.Pic-1.JPG
0
 
JohnBusiness Consultant (Owner)Commented:
There are several organizers. Here is a list to get you started.

http://www.techsupportalert.com/content/best-free-file-disk-catalog-organizer.htm
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
camtzAuthor Commented:
Thanks for that.  I took a quick look at this site and it appears these are all organizers that allow you to quickly access what you want.  This is really not what I am looking for.  I am trying to put shortcuts of various tracks on a document of some type that I could add extra columns for other information I need.  Could I do this in Notepad?
0
 
JohnBusiness Consultant (Owner)Commented:
Notepad is a text application and it will not open an MP3 file either. I am not sure how else except for an MP3 organizer.
0
 
CompProbSolvCommented:
I've not worked with this at all, but did find the following online that may be what you need:
http://spreadsheetpage.com/index.php/tip/playing_mp3_files_from_excel/

Or look at post #6 here:
http://www.mrexcel.com/forum/excel-questions/612970-using-visual-basic-applications-run-open-audio-file.html
0
 
camtzAuthor Commented:
I figured it out. !!!!!!!!!!!!!!!!!!
All you have to do is bring it in to Excel as a link and it will open it without any problems.
Thanks anyway
Carlos
0
 
camtzAuthor Commented:
Thanks for your help
0
 
JohnBusiness Consultant (Owner)Commented:
Carlos - Thanks for the update and I was happy to help.
0
 
camtzAuthor Commented:
Glad we were able to figure this out.  The Hyperlink tool in Excel is really very useful and I had never used it.
Carlos
0
 
camtzAuthor Commented:
What do I do to close this question?
0
 
JohnBusiness Consultant (Owner)Commented:
You have closed it already.
0
 
camtzAuthor Commented:
Okay, I didn't know you could add additional comments after closing.  I thought I had already closed it.
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.