make PNG image visible in Excel

D

ddbb

I have an Excel macro that generates a hyperlink from Excel to an URL to
download a PNG image. The macro works OK but the image arrives back to Excel
as a 'png symbol' only, and is not visible. If I manually do a "New
WebQuery" I can see the image in the New WebQuery dialog box but on "Import"
all I get is a 'png symbol' only in "A1". "A1" is formatted for text.
If I cut and paste the URL through IExplore I get a Visible PNG image OK.
but that is to slow for a repetative and time dependant method..
Any suggestions would by most welcome..
 
Top