Windows Media 10 files into Excel

M

Melvin Cotterill

Hello;
I am running Windows XP Pro, Windows Media Player 10, and Windows Media
Bonus Pack for Windows XP. Everything seems to be functioning OK.
I am trying to export Media Player 10 data into an Excel 2003 spreadsheet in
accordance with the commands listed in the Bonus Pack. They do not seem to
work.
My goal is to be able to select/play, from an Excel spreadsheet, the CD's
stored on my hard drive. The reason is that Excel makes it easy to
edit/manipulate the data.
Evidently, CD music files get stored on the hard drive as .wma files which
do not work within Excel. Do I need to convert the .wma files to extension
..xxx so that Excel recognizes them? If so how do I accomplish this?
Thanks for all the help.

Sincerely Melvin
 
M

Mike Williams [MVP]

Melvin said:
Hello;
I am running Windows XP Pro, Windows Media Player 10, and Windows Media
Bonus Pack for Windows XP. Everything seems to be functioning OK.
I am trying to export Media Player 10 data into an Excel 2003 spreadsheet in
accordance with the commands listed in the Bonus Pack. They do not seem to
work.
My goal is to be able to select/play, from an Excel spreadsheet, the CD's
stored on my hard drive. The reason is that Excel makes it easy to
edit/manipulate the data.
Evidently, CD music files get stored on the hard drive as .wma files which
do not work within Excel. Do I need to convert the .wma files to extension
.xxx so that Excel recognizes them? If so how do I accomplish this?
Thanks for all the help.

Excel is not a music player so trying to open WMA and MP3 files etc with
it is kinda foolish. The best you could do really is create hyperlinks
to the music files in Excel so that they invoke WMP to load the files on
demand.

What problem, specifically, are you having with the Bonus pack
outputting playlist data to an Excel-compatible file?
 
M

Mike Williams [MVP]

Melvin said:
Thanks for responding. How do you create the hyperlinks you mention?

Use the hyperlink creation button in Excel. There's one in pretty much
all Office applications.
 
M

Melvin Cotterill

Hello again Mike;
Thanks for the hyperlink suggestion in Excel. This worked fine..... so I am
up, up and away. I have the sinking feeling I was making my project complex
when in reality the solution was before my very eyes.......oh, well...bit of
a sticky wicket I say.

Sincerely
Melvin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top