Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to embed WAV files
2 views
Skip to first unread message
Julian
Dec 4, 2001, 6:48:42 PM12/4/01
to
Hi everyone.
More WAV questions.
1. How do I embedded a WAV file?
2. How do I play a embedded WAV file.
By the way Chip, your macros playing WAV file worked. My mistake.
Regards,
Julian
Greg Koppel
Dec 4, 2001, 6:56:51 PM12/4/01
to
1. Go to the Insert menu and choose wave file
2. Sub PlayItAgain()
ActiveSheet.Shapes("Object 3").Select
Selection.Verb Verb:=xlPrimary
End Sub
2. Sub PlayItAgain()
ActiveSheet.Shapes("Object 3").Select
Selection.Verb Verb:=xlPrimary
End Sub
HTH, Greg
"Julian" <bi...@yahoo.com> wrote in message
news:b4a6feb1.0112...@posting.google.com...
Chip Pearson
Dec 4, 2001, 10:01:52 PM12/4/01
to
Julian,
Try something like the following:
With ActiveSheet.OLEObjects.Add( _
Filename:="c:\windows\media\logoff.wav", link:=True)
.Visible = True
.Name = "MyWaveObject1"
.Verb xlVerbPrimary
End With
The .Verb method plays the sound.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com
"Julian" <bi...@yahoo.com> wrote in message
news:b4a6feb1.0112...@posting.google.com...
0 new messages