Can I run animated GIF's in Excel 2

[beanxx]

May be a stupid question, but is it at all possible to attach and run animated GIF's from within an Excel spreadsheet? If so how?

 

[xlbo]

AFAIK - nope. The only workaround I know of is to get the different images as JPGs and use VBA to flick thru them to give the impression of animation Rgds
~Geoff~

 

[onedtent]

else save the wb in HTML format and view it under a browser

 

[acron]

Or else put a browser in your worksheet. You can insert the MicroSoft WebBrowser control on a workshhet from the control ToolBox. Then to set the thing in morion just run some code like

Me.WebBrowser1.Navigate "Path\Anim.gif"

in the Worksheet Activate event

or

Sheets("SheetName&quot.WebBrowser1.Navigate "Path\Anim.gif"

"Path\Anim.gif" represents the path and filename ofyour animated gif.

Incidentally you can display any html document or indeed a webpage in you excel work sheet (or Word document) in the same manner.

It may take a bit of effort to have it working the way you want, but it is possible.

A.C.

 

[xlbo]

Acron - you da Man
How do you know this stuff ? ;-)
Whenever someone on this list posts an "AFAIK you can't" type post, you come in with some lovely little bit o' knowledge
Well worth a star Rgds
~Geoff~

 

[beanxx]

Acron and everyone else, thanks for this...given those pointers and a bit of work I should be able get the thing running. Oh and Acron I agree with Geoff, you are the man and I've given you a star.

Ta very much for the advice,
Justin