| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
web query in excel
I have some macros that pulls in data from a web site. the macros updates
the url, there is one for everyday with price information. However, every time i run the macro it creates a range "ExternalData_#" with the number representing the number of time the website has been queried. Some of the workbook have over 500 ExternalData_# ranges this slows the whole thing down. Does anyone know how to stop creation of a new range each time? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Threaded Mode
