Error in code - play music file automatically after opening file

[mukeshbaviskar]

Dear experts,
Please correct my code to play the music file automatically after opening the file.

Thanking you in anticipation.

Mukesh

[xLJer]

I worked this out in Excel 2003, going under the assumption that
you do not want to deal with an open media player after you close
Excel. This may not work, as is, for your Excel version, but give
my attached file a try to see if it has the effect you are looking for.
Then, if there are incompatibilities between Excel versions, someone
else on the forum may have an idea how to fix the problem.
This code goes in a new module:

Please Login or Register  to view this content.

[mukeshbaviskar]

Hello xLJer,
Excellent! It's working fine as per my requirement. I want to play the background instrumental music while working in excel. If you have any instrumental background music in mp3 format do send it to me on my personal email id as follows:

[email protected]

Now my problem is solved.

Thank you for your guidance.

Mukesh

[mukeshbaviskar]

Hello xLJer,
The song is of 10 minutes and then it didn't play again. If I want to repeat the song continuously till the file is open then what change should I do in code?

Thanking you in anticipation.

Mukesh

[xLJer]

To have the music file play repeatedly, do these steps.

In Sheet1 module, add this code:

Please Login or Register  to view this content.

In the module with the Auto_Open sub, change

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

When I run it, a bell (ding sound) rings after the file finishes. I was unable to find the reason for the bell.

[mukeshbaviskar]

Hello Jerry,
It sounds little confusing to me. Please do attach a excel sheet with codes to understand it me better and avoide any mistake.

Thanking you in anticipation.

Mukesh

[xLJer]

The workbook with revisions to play an MP3 file repeatedly is attached.

[mukeshbaviskar]

DearJerry,
Thank you. It's working fine.

Thank you.

Mukesh