RE: Adding bells and Whistles

[philhowell]

I've just finished a rather fancy programme intergrating Access and Excel via a complex series of Modules and to add the cherry to the top of the cake i'd like to be able to trigger the computers on-board sound devise (the one used for alert messages etc.. not the sound card / speakers etc..) to play a little melody...

any suggestions

cheers
phil

p.s.

something by Mozart would be nice....

 

[Andrew Poulsom]

Follow this link:

http://j-walk.com/ss/excel/tips/tip59.htm

 

[philhowell]

the computers dont have sound cards to play wav files so, it would have to be through the same speaker that makes the alert sound...

 

[Andrew Poulsom]

How good are you at composing?

http://www.c7r.com/abc/

 

[philhowell]

not very good at all.!

that's the sound i want to make.... but how do i trigger it in excel (and access if poss)

 

[Andrew Poulsom]

I suppose you could use the Shell method to call the program that plays the tune.

 

[philhowell]

could you give me an example of VBA code that would do that...

cheers
phil

 

[Andrew Poulsom]

http://j-walk.com/ss/excel/eee/index.htm

 

[philhowell]

Sorry, i can't seem to find it on their

 

[Andrew Poulsom]

Issue No 14 - Shell and wait procedure.