Down Loading External Data From Web. VBA to Control it

[lwchapman]

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

 

[Randy Harmelink]

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/

 

[Don Guillett]

I haven't tried this with 2007 but one way to build an external query is
goto the web site>place your cursor>right click>export to ms excel>etc. I
often build queries like this for my clients.

 

[lwchapman]

I would like to thank Don Guillett and Randy Harmelink for their excellent
response to my question. Both suggestions were very helpful.

Thank you two gentlemen!

Regards - Larry