+ Reply to Thread
Results 1 to 3 of 3

Convert Image URLs To Actual Images - specific PNGs wont import

  1. #1
    Registered User
    Join Date
    03-22-2007
    Posts
    23

    Convert Image URLs To Actual Images - specific PNGs wont import

    Was using the VBA examples from How To Convert Image URLs To Actual Images In Excel? https://www.extendoffice.com/documen...-from-url.html

    Code below.

    Using thier example it works fine. Use other im ages off web and it works. But the one site I need to pull images from seems to not be working. Its a Form website called Formsite. When a user uses the "Signature" field and signs name with finger or stylues it converts the signature into a PNG and puts the URL for that signature image in the results spreadsheet. For whatever reason, those correct URLs wont make it into Excel. Checked with the company and ther is nothing server-side that would block or prevent it. I did notice the image had that new buggy Chrome issue where it makes transparant backgrounds black. It will look like there is no signture image in Chrome because the signature is black and the Chrome background it black. Wierd. Cant image tjhat would cause the issue as a PNg is a PNG.

    Signature image: https://fs22.formsite.com/ucem/files...5_Wa8RRX8W.png In Developer mode if you set bkgrnd to white it shows.

    Here is the code. Cant tell what it is about my images that prevents it from working.

    Please Login or Register  to view this content.
    Thanks!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Convert Image URLs To Actual Images - specific PNGs wont import

    I have noticed for some time excel does not like .png.

    I placed url .jpg files on your sheet and used your code, it worked fine.

    Using .png files, it errors.
    You don't see the error because of the error line.

    'On Error Resume Next

  3. #3
    Registered User
    Join Date
    03-22-2007
    Posts
    23

    Re: Convert Image URLs To Actual Images - specific PNGs wont import

    Thanks for the reply. Unfortunately, the web form system I use to capture the images (Formsite) default downloads as PNG.

+ 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. Macro to auto-import images, resize them, and fit them to specific locations on the page
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2018, 04:55 PM
  2. Import data from specific HTML element based URLs in a column
    By whatever61 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2016, 08:04 AM
  3. [SOLVED] Convert all pictures & images in specific folder to vba
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-03-2015, 05:50 AM
  4. Download images from a list of urls (in excel sheet) to my local disk
    By anto888 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2012, 04:02 AM
  5. [SOLVED] extract urls from hyperlinked images
    By simarui in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2012, 04:11 PM
  6. Add URLs based on number of images
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 08-04-2011, 12:29 PM
  7. VBA Macro to fetch images based on URLs in sheet
    By jhodges in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2010, 08:38 AM

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