New Run-Time Error with Embedded Wavs

G

golf4wff

Hi, everyone -
I've been away for a little while - things going nuts at the
office..... BUT I'M BACK!!!!!

I just started experiencing a run-time error in macros created with my
income calculation spreadsheet that is driving me crazy!!! I'm hoping
the resident experts can give me a clue on how to resolve it. Within in
calcilation spreadsheet, I have quite a few macros that include wav
files within the macro. Our computers are running on Windows XP and
Excel 2002. The spreadsheet, and all the macros, have been running just
fine UNTIL we started replacing computers. Now, for an unknown reason,
we're getting the following run-time error:

"Run-Time Error '1004': Cannot start the source application for this
object".

The new machines are running the exact same version of operating system
and Excel as the old machines. Our systems person seems to think it may
be because of a conflict with McAfee, but we're running McAfee on the
old computers and we have no problems with any of the macros. My
thinking is that it may be because of the different versions of Windows
Media Player.

Has anyone experienced this or can, maybe, give me a clue on which
settings to check beween the two sets of computers? It would take me
FOREVER to revise all my macros to remove the wavs.

Thanks for the help.

Golf (Frank)
 
G

golf4wff

Hi, everyone -
I've been away for a little while - things going nuts at the
office..... BUT I'M BACK!!!!!

I just started experiencing a run-time error in macros created with my
income calculation spreadsheet that is driving me crazy!!! I'm hoping
the resident experts can give me a clue on how to resolve it. Within in
calcilation spreadsheet, I have quite a few macros that include wav
files within the macro. Our computers are running on Windows XP and
Excel 2002. The spreadsheet, and all the macros, have been running just
fine UNTIL we started replacing computers. Now, for an unknown reason,
we're getting the following run-time error:

"Run-Time Error '1004': Cannot start the source application for this
object".

The new machines are running the exact same version of operating system
and Excel as the old machines. Our systems person seems to think it may
be because of a conflict with McAfee, but we're running McAfee on the
old computers and we have no problems with any of the macros. My
thinking is that it may be because of the different versions of Windows
Media Player.

Has anyone experienced this or can, maybe, give me a clue on which
settings to check beween the two sets of computers? It would take me
FOREVER to revise all my macros to remove the wavs.

Thanks for the help.

Golf (Frank)
Click to expand...

Please bump...........
 
P

Pete_UK

I don't understand what you mean by having embedded .wav files. I have
made use of the techniques described here:

http://www.cpearson.com/excel/excelM.htm#PlayWAV

and the .wav files are kept in a separate folder. This doesn't call
Media Player directly. Not sure if this helps you with your problem -
perhaps you can post the part of the macro which calls Media Player,
and someone else might be able to comment.

Pete
 
G

golf4wff

Hi, Pete:

Here is an example of my code.

Sub PrintParkWestWorksheet() 'Print Park West worksheet'
Sheets("data_entry_sheet").Unprotect ("xxxxx")

ActiveSheet.Shapes("object 297.wav").Select 'romulan button2 sound'
Selection.Verb Verb:=xlPrimary

Sheets("data_entry_sheet").Protect ("xxxxx")

Sheet26.Select
Sheet26.PrintOut copies:=2
Sheet2.Select
[a1].Select
End Sub

The way I have the spreadsheet set up is that the majority of the wav
files are embedded on the Data Entry Sheet. When the code activates
the macro, the Data Entry Sheet unprotects, the wav plays and the page
re-protects itself. This has always worked fine ---- until we obtained
the new machines...... STUMPER, HUH??? ;)

Thanks for any help you can provide.
 
Top