VBA to kick off audio or jpeg

Hello,

I've built a few macros for some tools we run....but I'd like to have some fun with them. Is it possible to have a jpeg appear on the screen at the end or for a macro to kick off an audio file? The file could be kept on another drive etc. I know it's an odd question. I appreciate your help.

J

Hi JonathanB2,

The following code will play a .wav file. I have never attempted using jpegs in that way. The 64 bit conditional compilation has never been tested, since I only have 32 bit Excel. You have to supply your own .wav file in the same folder as the file running the code.

Lewis

Please Login or Register  to view this content.

Robert,

Your ShellExcecute command string works as follows when run with Windows Vista and Excel 2003:
a. It runs the default program associated with the .wav file (in my case Windows Media Player) which is visible when played. I tried to make it hidden with a ShellExecute option, but was not successful.
b. Windows Media Player has to be manually closed.

Lewis

J,

After some research I was able to come up with 6 ways to display an image. I imagine there are a lot more, and most are probably more efficient than the ones I came up with:
a. Embed image on a Sheet using 'Pictures.Insert'.
b. Embed image on a Sheet using 'Shapes.AddPicture'.
c. Embed image in a UserForm at design time.
d. Embed image in a Chart (called 'myChart').
e. Embed image in a UserForm at run time.
f. Embed a jpg file in a UserForm at run time.

Complete code follows along with a sample working file and also a sample .jpg file:

Please Login or Register  to view this content.

Lewis