View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ozzmantsje Ozzmantsje is offline
external usenet poster
 
Posts: 3
Default 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