How can I display a full screen picture?

Edd

New Member
Joined
Oct 16, 2002
Messages
2
I am trying to use Excel 2000 to display full screen .mpeg, .avi etc. movie clips, and .jpg, .bmp etc. images, I use a macro to return all the files in a folder on the desktop, and list them in a column, and then sort them to give a random play order. I have added an ActiveX mediaplayer to the worksheet, and the macro opens the files in turn, if a movie is played, the EndOfStream event causes the next file to be opened, if an image is opened, it is displayed for a set time before the next file is opened.
Now the problem, I want to be able to interrupt the macro and move on to the next file by pressing a designated cancel key, I can do this using OnKey, if a movie file is playing, but I can’t figure out how to interrupt the timer if a still image is opened. Any ideas gratefully received.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,144,221
Messages
5,723,115
Members
422,478
Latest member
Rovan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top