-
Different sound file question - simple ??
I have seen the different posts on playing a sound when a file is opened and those when an event occurs such as a cell reaching a certain value.
I have not been able to find instructions on how to cause a sound file to play from inside a macro when called.
Would I need code in the ThisWorkbook portion and code inside the macro or have a separate macro for the sound file and then call the sound macro from inside the main macro ? This seems to be a simpler instance for a sound file but have not seen a post covering this.
Since I am new to VBA please be specific if anything needs to go into the macro and what if anything needs to go into the ThisWorkbook thingee....
Oh, and can the soundfile be embedded into the excel file and if so, how does that change the coding required ??
Any help would be appreciated !
thanks!
Last edited by bdsii; 10-08-2009 at 06:48 PM.
-
Does this work for you? Also, have a look at this.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules