Re: Import data from a secure website to Excel
- From: Randy Harmelink <rharmelink@xxxxxxxxx>
- Date: Wed, 10 Oct 2007 20:44:22 -0000
It sounds like you'll need to use the IE object to navigate the
website and grab the data. Not something easily explained, especially
when talking about the details -- it requires examination of the web
page structure and the objects it contains. When I learned how to do
it, it was by examining various examples on the Internet that I found
using a search engine like Google. For example:
http://www.google.com/search?q=vba%20InternetExplorer&num=100
For the most part, I stopped doing that after I wrote the add-in. But
you can use the IE object to enter data into text boxes and click on
objects.
On Oct 10, 1:11 pm, Matheus <Math...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Randy, it's been a while since the last post. Now my company changed the
intranet system I was trying to get data from and basically I'll have to
start this discussion again.
On this new version here is what I have to do, that I would really be
interested on excel doing it for me:
.
- References:
- Re: Import data from a secure website to Excel
- From: Matheus
- Re: Import data from a secure website to Excel
- Prev by Date: RE: commandbutton removal
- Next by Date: Re: Shade Cells Yellows if Column (D) has a value of C in Cell
- Previous by thread: Re: Import data from a secure website to Excel
- Next by thread: Re: Import data from a secure website to Excel
- Index(es):
Relevant Pages
|
