Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to insert Open File action in the IF Function?
Hello, How can I insert the Open File action (w/o any other messages) in the
IF function - =IF (A1=A2,"C:\TRUE.WAV","C:\FALSE.WAV") or smth like that. I don't know how to write a Macros at all, so if anyone willing to write it for me I'll be grateful, though explanations will be required. My global problem is that I get some data from the web (the links are refreshing automatically) and I wanna do some kind of check - if the data is useful for me than a sound will be played to inform me, if not - silence. |
#2
|
|||
|
|||
http://support.microsoft.com/default...b;en-us;213777
XL2000: How to Play Sounds Using Visual Basic for Applications http://support.microsoft.com/default...b;en-us;158140 XL: How to Play Sounds Using Visual Basic for Applications http://support.microsoft.com/default...kb;en-us;86281 HOWTO: Play a Waveform (.WAV) Sound File in Visual Basic [Contains the Constants for the Arguments] http://support.microsoft.com/default...b;en-us;170730 WD: How to Play a .wav Sound File by Using a Macro http://support.microsoft.com/default...b;en-us;211842 WD2000: How to Play a .wav Sound File Using a Macro http://support.microsoft.com/default...b;en-us;193223 HOWTO: Use the MessageBeep API to Play System .WAV Files Use the Change Event to trigger you macro - See Chip Pearsons's page on events http://www.cpearson.com/excel/events.htm See David McRitchie's site on getting started with VBA and VBA tutorials. http://www.mvps.org/dmcritchie/excel/getstarted.htm http://www.mvps.org/dmcritchie/excel....htm#tutorials -- Regards, Tom Ogilvy "Majesty" wrote in message ... Hello, How can I insert the Open File action (w/o any other messages) in the IF function - =IF (A1=A2,"C:\TRUE.WAV","C:\FALSE.WAV") or smth like that. I don't know how to write a Macros at all, so if anyone willing to write it for me I'll be grateful, though explanations will be required. My global problem is that I get some data from the web (the links are refreshing automatically) and I wanna do some kind of check - if the data is useful for me than a sound will be played to inform me, if not - silence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open an xl97 file | Excel Discussion (Misc queries) | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
Why Excel file doesn't open by double click. | Excel Discussion (Misc queries) | |||
My document won't open, tells me file format is not valid | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) |