Thread
:
Query retrieving data from the web - excel 2003
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Query retrieving data from the web - excel 2003
Post your code or send me a workbook to look at
--
Don Guillett
SalesAid Software
"Bryan" wrote in message
...
I have a spreadsheet that has two macros in excel. I use the first marcro
to
retrieve data from a web page (stock quotes) using . The second macro is
used to copy the data and paste selective parts of the retrieval from the
query.
My problem is that I have a large list of data to go through and I would
like to start the process and have excel go through each line and complete
the process without me having to run each macro individually. When I
tried
to combine the two queries into one, the second query will not wait for
the
web page data to flood before it runs. When I place a loop or wait action
in
place, the data does not come over from the web.
Can someone point me in the right direction? I am not extremely
proficient
in this but can follow directions and appreciate any help.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett