Results 1 to 8 of 8

Thread: Inserting an gif file in Excel

  1. #1
    Join Date
    Dec 2008
    Posts
    165

    Inserting an gif file in Excel

    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Inserting an gif file in Excel

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

  3. #3
    Join Date
    Dec 2008
    Posts
    165

    Re: Inserting an gif file in Excel

    I am using Office XP.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,139

    smile Re: Inserting an gif file in Excel

    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.

  5. #5
    Join Date
    Dec 2008
    Posts
    165

    ThumbsUp Re: Inserting an gif file in Excel

    Thanks Chroma it worked out for me.

  6. #6
    Join Date
    Jun 2009
    Posts
    1

    Re: Inserting an gif file in Excel

    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

  7. #7
    Join Date
    Mar 2010
    Posts
    1

    Re: Inserting an gif file in Excel

    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 !

  8. #8
    Join Date
    May 2008
    Posts
    3,316

    Re: Inserting an gif file in Excel

    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.

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 02:11 PM
  2. Replies: 3
    Last Post: 01-02-2012, 07:45 PM
  3. Inserting a Row at the end of a Table in Microsoft Excel
    By Ramanujan in forum MS Office Support
    Replies: 2
    Last Post: 01-02-2012, 02:06 PM
  4. Replies: 3
    Last Post: 07-01-2012, 11:37 AM
  5. Issue while inserting pivot Tables in Excel 2003
    By Clemens in forum Windows Software
    Replies: 3
    Last Post: 29-04-2009, 04:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,710,838,150.50256 seconds with 16 queries