Excel - Down Loading External Data From Web. VBA to Control it

Asked By lwchapma

23-Mar-08 03:29 PM

I currently update one of my programs by using the external data option on
the Data Tab of the ribbon.  There are 6 different websites that I query at
concurrent times.

What I need to do is control some sites from being downloaded at certain
times, plus do some other operations with it.  I have searched and searched
MS help for VBA that would allow me to do this.  All I can find is
information on using the data and properties option help using the Data Tab
on the ribbon.  No reference to manipulating  external data from the web with
VBA.

Is there someone there that can lead me to the VBA statements, syntax or
whatever to accomplish the above?

I use XP Pro and Excel - Office 2007.

Regards,

Larry

24-Mar-08 06:37 AM

I have a free open-source add-in that may help.  It has a number of
user-defined functions that are used to grab data off of web pages.
If they don't meet your needs, you can review some of the VBA code to
see if something in there can help you achieve your goal.  The add-in
and documentation on its functions can be found in the files area of
this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin/

On Mar 23, 12:29 pm, lwchapman <lwchap...@>