Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
single web query without adding to defined names
Hi,
I am gathering information from a website through a webquery. The result is a table of article data which is then pasted into a sheet. The thing with the webqueries is that they also add a named data range definition, which I do not need. I want the webquery to be run through an add-in, without adding any definitions. I could delete the definition with the same name as the webquery, but excel adds a number to the names like name_1, name_2 etc. Is there a way to just do one single webquery without adding the definition every time? Thanks! Oscar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
single web query without adding to defined names
Yes, Establish the query ONCE and then refresh. If you are using more than
one just use the variable within the url. Contact me privately if you want to send your workbook for a look -- Don Guillett Microsoft MVP Excel SalesAid Software "Ozzmantsje" wrote in message ... Hi, I am gathering information from a website through a webquery. The result is a table of article data which is then pasted into a sheet. The thing with the webqueries is that they also add a named data range definition, which I do not need. I want the webquery to be run through an add-in, without adding any definitions. I could delete the definition with the same name as the webquery, but excel adds a number to the names like name_1, name_2 etc. Is there a way to just do one single webquery without adding the definition every time? Thanks! Oscar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why use defined names? | Excel Discussion (Misc queries) | |||
defined names | Excel Worksheet Functions | |||
Defined Names | Excel Programming | |||
User defined function - adding names | Excel Programming | |||
Using defined names in VBA... | Excel Programming |