Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jack Sons
 
Posts: n/a
Default beep suddenly won't work

Hi all,

Suddenly my Excel (2K) beep won't work anymore, neither in excisting code
nor in new code. For instance the code below does nothing.

Sub Macro6()
Beep
Beep
Beep
End Sub

All other Windows (XP SP) sounds still work, but I'm not sure of Word
because as far as I can remember I don't do things in Word that generate
sound. I tried the macro below and there was no sound.

Sub test_sound()
Beep
End Sub

Where should I look for what is wrong? Your help will be appreciated.

Jack Sons
The Netherlands


  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

Is your speaker card turned on? Or you could use this for your internal
speaker.

A search on this
http://makeashorterlink.com/?D24E42426
showed among lots of things this:


" In VB, the Beep function calls the Windows Exclamation sound, so if you
have a sound card driver installed, the sound will be emitted by the
sound card.


" If your app is being run under WinNT4, Win2000, or WinXP, you can use the
Beep API function to play a sound using the internal speaker. Win9x does
not support this (like VB's Beep statement, the Beep API function under
Win9x only plays the Default Sound .wav file).


Private Declare Function Beep Lib _
"kernel32" (ByVal dwFreq As Long, _
ByVal dwDuration As Long) As Long


Sub BeepMe()


Dim frequency As Long
Dim duration As Long


frequency = 1600
duration = 500


Call Beep(frequency, duration)


End Sub


--
HTH. Best wishes Harald



--
Don Guillett
SalesAid Software

"Jack Sons" wrote in message
...
Hi all,

Suddenly my Excel (2K) beep won't work anymore, neither in excisting code
nor in new code. For instance the code below does nothing.

Sub Macro6()
Beep
Beep
Beep
End Sub

All other Windows (XP SP) sounds still work, but I'm not sure of Word
because as far as I can remember I don't do things in Word that generate
sound. I tried the macro below and there was no sound.

Sub test_sound()
Beep
End Sub

Where should I look for what is wrong? Your help will be appreciated.

Jack Sons
The Netherlands




  #3   Report Post  
Jack Sons
 
Posts: n/a
Default

Don,

The internal sound is barely audible and not a good substitute for the
standard beep.

In Control Panel -- Sounds -- Windows -- Exclamation mark I sea the speaker
symbol in front of it. In the drop down box below "Sounds:" I see "Windows
XP Explanation.wav and when I click the horizontal arrow at the right hand
side I hear the proper sound coming out of my speakers. So my speaker card
is turned on and in principle the exitation of the Windows Explanation sound
works. Other souds also work well, like for incoming mail, starting Windows
etc.

I tried (from the Excel help function):

Sub beepsound()
Dim I
For I = 1 To 3
Beep
Next I
End Sub

but I get an errormessage saying (translated from Dutch)
"Compiling error. The argument is not optional".
I have absolutely no inea what this means.

You wrote: "In VB, the Beep function calls the Windows Exclamation sound".
Where is the connection, could that be disrupted somewhere?

Can you help?

Jack.

"Don Guillett" schreef in bericht
...
Is your speaker card turned on? Or you could use this for your internal
speaker.

A search on this
http://makeashorterlink.com/?D24E42426
showed among lots of things this:


" In VB, the Beep function calls the Windows Exclamation sound, so if you
have a sound card driver installed, the sound will be emitted by the
sound card.


" If your app is being run under WinNT4, Win2000, or WinXP, you can use
the
Beep API function to play a sound using the internal speaker. Win9x does
not support this (like VB's Beep statement, the Beep API function under
Win9x only plays the Default Sound .wav file).


Private Declare Function Beep Lib _
"kernel32" (ByVal dwFreq As Long, _
ByVal dwDuration As Long) As Long


Sub BeepMe()


Dim frequency As Long
Dim duration As Long


frequency = 1600
duration = 500


Call Beep(frequency, duration)


End Sub


--
HTH. Best wishes Harald



--
Don Guillett
SalesAid Software

"Jack Sons" wrote in message
...
Hi all,

Suddenly my Excel (2K) beep won't work anymore, neither in excisting code
nor in new code. For instance the code below does nothing.

Sub Macro6()
Beep
Beep
Beep
End Sub

All other Windows (XP SP) sounds still work, but I'm not sure of Word
because as far as I can remember I don't do things in Word that generate
sound. I tried the macro below and there was no sound.

Sub test_sound()
Beep
End Sub

Where should I look for what is wrong? Your help will be appreciated.

Jack Sons
The Netherlands






  #4   Report Post  
Jack Sons
 
Posts: n/a
Default

Don,

BTW, what is an API function?

Jack.

"Don Guillett" schreef in bericht
...
Is your speaker card turned on? Or you could use this for your internal
speaker.

A search on this
http://makeashorterlink.com/?D24E42426
showed among lots of things this:


" In VB, the Beep function calls the Windows Exclamation sound, so if you
have a sound card driver installed, the sound will be emitted by the
sound card.


" If your app is being run under WinNT4, Win2000, or WinXP, you can use
the
Beep API function to play a sound using the internal speaker. Win9x does
not support this (like VB's Beep statement, the Beep API function under
Win9x only plays the Default Sound .wav file).


Private Declare Function Beep Lib _
"kernel32" (ByVal dwFreq As Long, _
ByVal dwDuration As Long) As Long


Sub BeepMe()


Dim frequency As Long
Dim duration As Long


frequency = 1600
duration = 500


Call Beep(frequency, duration)


End Sub


--
HTH. Best wishes Harald



--
Don Guillett
SalesAid Software

"Jack Sons" wrote in message
...
Hi all,

Suddenly my Excel (2K) beep won't work anymore, neither in excisting code
nor in new code. For instance the code below does nothing.

Sub Macro6()
Beep
Beep
Beep
End Sub

All other Windows (XP SP) sounds still work, but I'm not sure of Word
because as far as I can remember I don't do things in Word that generate
sound. I tried the macro below and there was no sound.

Sub test_sound()
Beep
End Sub

Where should I look for what is wrong? Your help will be appreciated.

Jack Sons
The Netherlands






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
Work book shared kiran Excel Discussion (Misc queries) 8 June 22nd 05 05:47 AM
Work book formulas Jessica Excel Discussion (Misc queries) 1 June 9th 05 10:51 AM
I wish to save my Excell work in my work sheets CLC 37 Qld Excel Worksheet Functions 0 May 24th 05 10:56 AM
How to copy the work sheets from different workbooks into one? Sesh Excel Discussion (Misc queries) 1 April 15th 05 06:03 PM
Change Path names in copied work book jheaney Excel Worksheet Functions 2 November 18th 04 07:29 PM


All times are GMT +1. The time now is 11:16 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"