ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   extract data from web (https://www.excelbanter.com/excel-programming/395443-extract-data-web.html)

scott

extract data from web
 
I need to extract data from a website by first clicking a linking and opening
up a new page. On this page, I have to type a customer number and then click
'search'. So it opens up the customer's info page. Then I have to click a
certain link to open up the invoice page and download that page to Excel or
Word. I have a list of hundreds of customers. Can vba do the whole process
for me?

Don Guillett

extract data from web
 
Yes, but you may need professional help. More than usually done thru the
newsgroup. Post some sample url's etc.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Scott" wrote in message
...
I need to extract data from a website by first clicking a linking and
opening
up a new page. On this page, I have to type a customer number and then
click
'search'. So it opens up the customer's info page. Then I have to click a
certain link to open up the invoice page and download that page to Excel
or
Word. I have a list of hundreds of customers. Can vba do the whole process
for me?




All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com