web, querytable &jpg
Have working code that does 'querytable Add connection' . This retreives the
web page into a worksheet OK. When I try to retreive a jpg file, the same code works, but the jpg file photo is all garbage in the receiving cell. With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http//:www.images.com/photo/boss.jpg", Destination:=Sheets("dummy").Range("B20")) .BackgroundQuery = True .TablesOnlyFromHTML = False .Refresh BackgroundQuery:=False .SaveData = True End With How do I get a jpg to display as required? TIA |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com