Hi
I am trying to insert a picture from a website into an excel sheet, but I get an error message, no matter which method I try.
The URL I use ("MyURL") is in the format:
https://x.x.x.x:pppp/chart.png?id=1002&graphid=2&mapid=secretkey
But if I use any other picture url, it works... even if it has parameters, eg.
http://www.mrexcel.com/forum/avatars/[personsname].gif?dateline=2007
MyUrl works fine in any browser, but not in Excel.
I have used these methods:
A) Pictures.Insert
ActiveSheet.Pictures.Insert ("MyURL")
* gives error: "Runtime error 1004: Unable to get the Insert property of the Pictures class"
B) Shapes.AddPicture
wsht.Shapes.AddPicture "MyURL", msoFalse, msoTrue, 0, 0, 100, 100
* gives error: "Runtime error 1004: The specified file was not found"
C) Insert > Pictures > Paste URL in file name
* I get the message "An error occurred while importing this file"
D) Convert MyUrl into a short URL
* I get the error messages:
A - "Insert method of picture class failed"
B - "The specified file was not found"
C - "An error occurred while importing this file"
My system:
Windows 8, Excel 2013
What is the problem?
I am trying to insert a picture from a website into an excel sheet, but I get an error message, no matter which method I try.
The URL I use ("MyURL") is in the format:
https://x.x.x.x:pppp/chart.png?id=1002&graphid=2&mapid=secretkey
But if I use any other picture url, it works... even if it has parameters, eg.
http://www.mrexcel.com/forum/avatars/[personsname].gif?dateline=2007
MyUrl works fine in any browser, but not in Excel.
I have used these methods:
A) Pictures.Insert
ActiveSheet.Pictures.Insert ("MyURL")
* gives error: "Runtime error 1004: Unable to get the Insert property of the Pictures class"
B) Shapes.AddPicture
wsht.Shapes.AddPicture "MyURL", msoFalse, msoTrue, 0, 0, 100, 100
* gives error: "Runtime error 1004: The specified file was not found"
C) Insert > Pictures > Paste URL in file name
* I get the message "An error occurred while importing this file"
D) Convert MyUrl into a short URL
* I get the error messages:
A - "Insert method of picture class failed"
B - "The specified file was not found"
C - "An error occurred while importing this file"
My system:
Windows 8, Excel 2013
What is the problem?