zoso
Well-known Member
- Joined
- Oct 23, 2003
- Messages
- 725
Hi everyone
I have a .wav file embedded in a worksheet which runs on opening the file. I'm running Excel 2003, and the workbook still worked fine when I upgraded to Excel 2007. When I run Windows XP the sound file plays, and the worksheet opens where I'd previously been using it, which is perfect.
However, when I run the workbook in Vista the sound file still plays, but Excel now locates the embedded .wav file and then opens Windows Media Player (version 11), neither of which I want to happen!
Here's the relevant section of the code:
I hope you can help - thank you!
I have a .wav file embedded in a worksheet which runs on opening the file. I'm running Excel 2003, and the workbook still worked fine when I upgraded to Excel 2007. When I run Windows XP the sound file plays, and the worksheet opens where I'd previously been using it, which is perfect.
However, when I run the workbook in Vista the sound file still plays, but Excel now locates the embedded .wav file and then opens Windows Media Player (version 11), neither of which I want to happen!
Here's the relevant section of the code:
Code:
Private Sub Workbook_Open()
Sheets("Training Log").Select
Range("A20000").End(xlUp).Offset(0, 0).Select
ActiveSheet.Calendar1.Value = Date 'sets date to today's date
ActiveSheet.Shapes("BornToRun").Select
Selection.Verb Verb:=xlPrimary
Dim Wait As Boolean