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

"Don Guillett" wrote:

I haven't tried this with 2007 but one way to build an external query is
goto the web siteplace your cursorright clickexport to ms exceletc. I
often build queries like this for my clients.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"lwchapman" wrote in message
...
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