Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 9th, 2003, 05:10 AM
Registered User
 
Join Date: Oct 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.







Similar Threads
Thread Thread Starter Forum Replies Last Post
Pictures In Reports wb8bgy Visual Basic 2005 Basics 0 March 7th, 2007 09:55 AM
how we use legend of the pictures chichiboof Word VBA 2 October 18th, 2006 02:59 AM
jpg pictures boker990 VB.NET 2002/2003 Basics 2 July 12th, 2005 08:40 PM
Problem on Pictures mani_he Pro PHP 0 February 8th, 2005 05:03 PM
Pictures mani_he Pro PHP 5 October 28th, 2004 09:03 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.