I have several hundred fund symbols. I know how to use the Query and find the data and import it one at a time. But, is there away to do this automate this process so it runs in the back ground and refreshes the data when you open the Excel workbook? I am using excel 2003.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to automate "query for data from a web page"
- Thread starter i2trader
- Start date
SkipVought
Programmer
Hi,
Yes, but it takes VBA code forum707.
Please post in forum707.
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...for a NUANCE!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question