Thread
:
Web Querying from excel.
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Web Querying from excel.
Give me a sample of the final url and more info and I can help. What you
copy and where to. You might send your workbook to me to look at.
--
Don Guillett
SalesAid Software
wrote in message
om...
I often update an excel model with a web query every morning. I am
looking for a way to automate this procedure using VBA. I simply copy
a an array of data into an excel range.
Effectively I have to:
1) go to the website
2) use the websites drop down menus to pick html or CSV file
3) use the websites drop down menues to pick the report that I want
4) use drop down boxes to pick the date range that I want
5) press OK and the site will either download the data in a html table
or it will create a CSV file and prompt me with a windows File
Download prompt which gives me the option of opening it or saving it.
6) then I simply highlight the arrray of data I want and paste into a
range that never changes in an excel spreadsheet. For simplicity I
always use the same start date and only ever change the end date. The
result is an array that gets bigger every day as new data gets
updated. I simply paste this growing array over the previous days
data in the excel spread sheet.
Is it possible to automate this in an Excel spreadsheet using VBA?
Which option would be easier html table or CSV file?
Thanks
TS
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]