Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Querytable range name | Excel Programming | |||
How to use QueryTable with insertion sql | Excel Programming | |||
Bad QueryTable Row Count | Excel Programming | |||
Querytable | Excel Programming | |||
MS QUERY w/out querytable | Excel Programming |