Inserting an gif file in Excel

[Bassus]

Hi friends,
I want to add a animated gif file in my Excel sheet.Is there any way or procedure where i can add my file in excel Sheet.

[chroma]

Sure i can help you out with that before may ii know which Office are you using are Xp/2003/2007.

[Bassus]

I am using Office XP.

[chroma]

Sure you can add an Animated gif file to excel by following the Steps Below:-

1. You First need to insert the image into a control.
2. To insert the control,you need to go View menu-->Toolbars -->Control Toolbox
3. Then Activate the Design mode
4. Choose the button(the one with a hammer), then select Microsoft Web Browser.
5. Draw a frame to receive the image.
6. Disable the first button Design mode and the toolbar.
7. In VBA editor and in the window of the paper concerned paste the following code:
   
   Private Sub Worksheet_Activate()

   WebBrowser1.Navigate "X:\Full path of the image.GIF"

   End Sub

Change the active page of the spreadsheet, and then return on the page containing the animation, to see your animated gif file is working or not.

[Bassus]

Thanks Chroma it worked out for me.

[maxtor2]

Chroma,

I have a newbe question regarding your post, if you have the time...

I have not worked with VBA before so while I can get to the VBA editer in Excel (alt-F11), I am not sure how to "7.In VBA editor and in the window of the paper concerned paste the following code:" and then the step "Change the active page of the spreadsheet". I can copy and paste code and I have the full path of my gif I am just not sure where to put it.

Thanks in advance.

maxtor2

[sprimax]

I have a problem which made me feel so sad and unhappy. The code given was work out and excellent, but if you have to distribute and share to others, it won't worked ! Because the code cannot find the image (gif) that I store in my drive.

Is there any solution of it ?

Thank you !

[Raine]

The solution to this problem is quiet simple you need to give the gif file to with the code in order to make that working on a different system. Ask the user to change the path of the file that is replace the "X:\Full path of the image.GIF" from the above code with the path of the gif file. Hope this will help you.