+ Reply to Thread
Results 1 to 2 of 2

Trouble Displaying PNG from Web Query...?

Hybrid View

  1. #1
    Registered User
    Join Date
    02-07-2007
    Posts
    2

    Trouble Displaying PNG from Web Query...?

    I'd like to import a 'PNG image' from a web page

    (for example this chart: http://ichart.finance.yahoo.com/z?s=...=l&p=s&a=v&p=s )

    via the 'Import External Data - New Web Query' feature in Excel.

    Unfortunately, when I select the appropriate table and attempt to import it, instead of the image I want it returns this:

    ‰PNG

    with a '' in the cell below it.

    Any idea how to rectify this???

    I could - of course - just copy and paste the image, but I want to look at a few hundred charts and have written a macro to manipulate the addresses to import all the images I want, and certainly don't want to copy and paste each by hand (that would take several days).

    Any help would be most appreciated....

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    JS,

    I found a setting while looking for something else, oddly enough..

    Click Tools
    Click Options
    Click the General tab
    Click the 'Web Options' button
    In the Web Options screen, there's a checkbox for 'Allow PNG as a graphics format' (When you check this box, it changes the first box to 'Internet Explorer 6.0 and later'.)
    Click OK twice to return to your workbook.

    I'm not sure if that setting only applies to Saving Excel documents to web format, or if it will have a positive effect on your importing functionality too. Worth a shot, anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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