Deleting variable web query name

  • Thread starter Thread starter wayliff
  • Start date Start date
W

wayliff

Trying to delete a webquery range that is a variable.


ActiveWorkbook.Names("st_rejs").Delete

The first time is "st_rejs" and every time I run a macro the name maybe
st_rejs_1 or so 2 or 3.

How to rewrite this lines of code with that in mind?
 
Dim nm as Name
for each nm in Activeworkbook.Names
if nm.Name like "st_rejs*" then
nm.delete
end if
Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

single web query without adding to defined names 1
VBA: Delete name range 3
Delete Named rnage and Add Named Range 5
Run-time error "5" after range().delete runs before querytable.add 5
Redefining a table range with a macro 8
worksheet name store in a variable 3
Filesearch in 2007 1
delete defined names 4

Back
Top