+ Reply to Thread
Results 1 to 9 of 9

VBA Combine PNG/JPG to an animated Gif

  1. #1
    Registered User
    Join Date
    05-19-2022
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    4

    VBA Combine PNG/JPG to an animated Gif

    I have been searching on google on how to combine multiple PNG/JPG to an animated GIF using EXCEL VBA but found none. Can someone direct me in the right direction if this is possible?

    Basically i have already done the function to read png/jpg files from a specific file but require a function to combine (with a seconds) and save as animated GIF.

    Thanks in advance.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: VBA Combine PNG/JPG to an animated Gif

    Let me first make a general comment: Why not use dedicated tools, like https://ezgif.com/maker etc.

    Surely, you can nail a board with scisors, but it's better idea to use a hammer for this task.

    So give a good reason why it shall be done with VBA
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-19-2022
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    4

    Re: VBA Combine PNG/JPG to an animated Gif

    Kaper,
    I fully understand what you mean and thanks for trying to assist. I can implement the above with any other application, but the requirement was using VBA excel native

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: VBA Combine PNG/JPG to an animated Gif

    While I fully agree with the 'taking a doctors' reflex hammer to demolish a nuclear power station' comment - it's much better to use a sledge hammer to crack a nut but VBA is versatile, it may not be the best way but there usually is a way.

    Unfortunately, this is just to merge two JPGs so can only be used to get an idea of how, perhaps, you might be able to create an animated GIF....

    https://www.devhut.net/vba-wia-combi...erging-images/
    Last edited by cytop; 05-19-2022 at 05:25 AM.

  5. #5
    Registered User
    Join Date
    05-19-2022
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    4

    Re: VBA Combine PNG/JPG to an animated Gif

    I already saw and used this.

    What it actually does is combine them to one image showing them all at once side by side, and not animate a gif
    Last edited by biancoluke2; 05-19-2022 at 05:40 AM.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: VBA Combine PNG/JPG to an animated Gif

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new here, I will do this for you today:

    https://forum.ozgrid.com/forum/index...-animated-gif/

    https://www.vbforums.com/showthread....n-animated-Gif

    https://www.vbaexpress.com/forum/sho...n-animated-Gif
    )
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Contributor
    Join Date
    02-25-2022
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    174

    Re: VBA Combine PNG/JPG to an animated Gif

    With any image manipulation I always use Imagemagick (free). It a command line to that also has an ActiveX interface. Here is an article on how to do it. VBA can't do it.
    Last edited by mogul; 05-19-2022 at 11:38 AM.

  8. #8
    Registered User
    Join Date
    05-19-2022
    Location
    Malta
    MS-Off Ver
    Office 365
    Posts
    4

    Re: VBA Combine PNG/JPG to an animated Gif

    Hi,

    It seems you have a rule that wont allow me to link to the other websites. When i am trying to link the other websites i posted the below error occurs
    "You are not allowed to post any kinds of links, images or videos until you post a few times."

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: VBA Combine PNG/JPG to an animated Gif

    The rule says this:

    3. Questions that are cross-posted to other web forums must contain links to those posts on those forums or a comment to tell us where else the question has been asked.
    The OR clause is there because we know that new members cannot post links.

    We do not ask you to do things that you can't do. We also assume that you HAVE read the rules page, since you ticked a box to agree to those rules when you joined.

    I hope this is clear.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Animated charts
    By carmarti in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2019, 02:19 AM
  2. Animated gif's
    By bogey69 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2014, 07:06 PM
  3. Animated icons
    By amit.dude in forum Excel General
    Replies: 0
    Last Post: 05-21-2009, 06:39 AM
  4. Animated Gif on worksheet
    By Mike K in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2006, 01:32 AM
  5. [SOLVED] Animated GIF
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2006, 05:20 AM
  6. [SOLVED] Animated charts
    By unique in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-03-2005, 09:50 PM
  7. [SOLVED] Animated .gif
    By Brad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-25-2005, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1