Downloading Pictures into Charts
Hi,
I'm having problems getting VBA to reliably download pictures from websites and insert them into my charts. It seems that if the server/connection I'm accessing is fast, I get my picture, but if its a bit slow, the VBA code times out and moves onto the next line. The type of source that I'm using is:
ActiveSheet.Pictures.Insert("http://infoex.hemscott.net/info_img/EXCHANG8.GIF")
I've looked at ways of making VBA waiting using a Do Events and Wait statements but without success.
Any ideas/pointers?
Cheers
Berny.
|