Search results for query: *

Skip & strongm, Based on your feedback, figured that the problem must be caused by local settings. Changed the decimal indicator from , to . in control panel and guess what,....... all formulas work!!!!!!!!!!!!!! Took a week to solve this problem but very happy that it works now thanks to your...

Skip & strongm, First,... many thanks for your feedback, your support is very well appreciated!! I am still puzzled!!! How can the alarm formula work on one computer but doesn`t on another? And how can there be a problem with the data in the referenced cels while the alarm formula works on...

Skip, There are 5 different alarm function references in the linked file. I did this to show that the formula works when the reference is D3, but doesn´t work when the reference is D5,6,7 or 9. What I really don´t understand is that other people open the file and everything seems to be fine...

Skip, Thanks for your comments! There must be something with the comma format. When I replace the 5 in cel D3 with 12,54 the alarm function doesn`t work, but when I enter 12.54 in cel D3 it works again. Not sure though how to fix the problem though. Could you give some more hints please...

I am trying to configure an alarm based on the value of a cell which is linked to a web query The formula is: =Alarm(D7;">=1") The VBA code is: 'Windows API function declaration Private Declare Function PlaySound Lib "winmm.dll" _ Alias "PlaySoundA" (ByVal lpszName As String, _ ByVal hModule As...

I posted the related Excel file to MediaFire, hope you can access the links below. The question is,.. why does the alarm function return True in cel E3 and False in cels E5,6,7&9? Many thanks for your support!! Regards, Gert http://www.mediafire.com/?wmmmwyyminz...

looks like there is a limitation to the lenght of the url, please try this one.....http://tiny.cc/J3hDD

hope this link works.....http://spreadsheets.google.com/ccc?key=0Akl17DphP3fHdC1rRHU3VVRNb0ZZZ256UXkteG1RMkE&hl=en

Correct, the Alarm function is the following 'Windows API function declaration Private Declare Function PlaySound Lib "winmm.dll" _ Alias "PlaySoundA" (ByVal lpszName As String, _ ByVal hModule As Long, ByVal dwFlags As Long) As Long Function Alarm(Cell, Condition) Dim WAVFile As...

I am trying to configure an alarm based on the value of a cell which is linked to a web query The formula is =Alarm(A1;">=1") When I set the condition based on the value of cel A1 and type manually a number > 1 in cel A1, the alarm functions properly When I change A1 in the formula to D4 or D5...