Down Loading External Data From Web. VBA to Control it

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lwchapman - 23 Mar 2008 20:29 GMT

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

Reply to this Message

Randy Harmelink - 23 Mar 2008 23:23 GMT

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...@discussions.microsoft.com>
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
[quoted text clipped - 11 lines]
>
> I use XP Pro and Excel - Office 2007.

Reply to this Message

Don Guillett - 24 Mar 2008 13:34 GMT

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.

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>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
[quoted text clipped - 19 lines]
>
> Larry

Reply to this Message

lwchapman - 26 Mar 2008 02:04 GMT

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

> 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
[quoted text clipped - 23 lines]
> >
> > Larry

Reply to this Message