I'm trying to insert a picture from web to worksheet using
Sheets(1).Shapes.AddPicture "Picture_source" _
, msoFalse, msoTrue, 100, 100, 500, 600
but i get message, that picture wan not found. Picture exists on server. How to fix it?
I'm trying to insert a picture from web to worksheet using
Sheets(1).Shapes.AddPicture "Picture_source" _
, msoFalse, msoTrue, 100, 100, 500, 600
but i get message, that picture wan not found. Picture exists on server. How to fix it?
Last edited by pablito1; 02-23-2013 at 09:03 AM.
your code works, try
Please Login or Register to view this content.
If solved remember to mark Thread as solved
i copied your code and get: runtime 1004 file could not be found.
i'm using some code to get url's source code and it works, so it;s connecting to server, but inserting picture doesn't works
Hi,
Attached is your solution.
Hope this helps.
Happy Computing.
ActiveSheet.Pictures.insert "http://www.biesse.net/imagesmini/2220.jpg"
so i think it's something with my excel, because it doesn't work.
I get message: "Application-defined or object-defined error" at line where you insert files. So my question is : what is wrong with excel? something is missing?
I'm using excel 2007
Hi,
It would be best , if you could post your file. In that way we can all work towards solving the problem
Problem is, that even file posted by xlbiznes doesn't work so i think it is excel error, something wrong with my instalation.
i tried reinstalling excel but it changes nothing. However when i'm running code at different computer i works correctly. So what files could be corrupted, that shapes.addpicture doesn't work correctly?
Hi,
Did you try loading a file that is present locally on your computer ?
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
yes, and then it works fine
Hi,
when you copy paste one of the image url onto the address bar of your web browser , does it render the image ?
Go to the excel vba of the "load images from url.xlsx" file and then click on the tools and then click on references. You will see a window with the available references and references that are being used (ticked ones). Paste a screen shot of that ,so we can see if any references are missing .
Clipboard.jpg
yes, browser renders image. References in attached file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks