#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default WAV Files

I have a macro to play a wav file; however, I only want to play the first 30
seconds from it. Is there a way to modify my macros (see below) to stop
after 30 seconds?

Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
(ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub GameOver()
Call sndPlaySound32("C:\Sounds\Gameover.wav", 0)
End Sub
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,939
Default WAV Files

Playing a wav file is an all or nothing proposition. The easiest solution
would be to modify the wav file (using any number of downloads from the
internet) to only contain the first 30 seconds...
--
HTH...

Jim Thomlinson


"Paige" wrote:

I have a macro to play a wav file; however, I only want to play the first 30
seconds from it. Is there a way to modify my macros (see below) to stop
after 30 seconds?

Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
(ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub GameOver()
Call sndPlaySound32("C:\Sounds\Gameover.wav", 0)
End Sub

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 270
Default WAV Files

Thanks, Jim; will do!

"Jim Thomlinson" wrote:

Playing a wav file is an all or nothing proposition. The easiest solution
would be to modify the wav file (using any number of downloads from the
internet) to only contain the first 30 seconds...
--
HTH...

Jim Thomlinson


"Paige" wrote:

I have a macro to play a wav file; however, I only want to play the first 30
seconds from it. Is there a way to modify my macros (see below) to stop
after 30 seconds?

Declare Function sndPlaySound32 Lib "winmm.dll" Alias "sndPlaySoundA" _
(ByVal lpszSoundName As String, ByVal uFlags As Long) As Long

Sub GameOver()
Call sndPlaySound32("C:\Sounds\Gameover.wav", 0)
End Sub

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigating to Excel files over network slow, but not Word files Newbie123 Excel Discussion (Misc queries) 1 December 2nd 09 01:18 PM
How can I batch convert 97-2003 .xls files to 2007 .xlsx files Dave Nuttall Excel Discussion (Misc queries) 4 August 3rd 09 11:38 PM
How to change default Open/Files of Type to "Microsoft Excel Files Tammy Excel Discussion (Misc queries) 2 January 14th 08 11:06 PM
how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file George Excel Programming 0 October 5th 06 04:14 PM
Macro to open *.dat files and save as .txt (comma delimited text files) [email protected] Excel Programming 2 November 30th 05 05:50 AM


All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"