Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query retrieving data from the web - excel 2003
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
Retrieving Data in excel | Excel Worksheet Functions | |||
Retrieving the SQL query of the external data range | Excel Programming | |||
Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) | |||
Retrieving FoxPro Data using Query | Excel Programming |