Down Loading External Data From Web. VBA to Control it
 

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

Down Loading External Data From Web. VBA to Control it
 

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
wrote:
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.

Down Loading External Data From Web. VBA to Control it
 

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

Down Loading External Data From Web. VBA to Control it
 

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