Web Queries

  • Thread starter Thread starter Pelham
  • Start date Start date
P

Pelham

I have a spreadsheet with about 450 different Web Queries in it which
have been created with a VBA Macro. Does anyone know how to remove all
the Web Queries in one hit once the Macro has stopped running?

I have tried CTRL-A and then right clicking to remove the Web Query but
it does not seem to remove all of them...
 
You may want to have exclusions or if left(name to NOT remove some names.

Sub DeleteAllNames()
For Each Name In Names
Name.Delete
Next Name
End Sub
 
Thanks Don!

But, how exactly does this VBA script remove all my embedded Web
Queries because I cannot see how this script can find the 450 odd Web
Queries in my worksheet without a reference to the Web Queries
themselves...?
 

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

Web Queries 1
Can this be done? 1
Runtime Error 1004 1
Help - Excel 2007 web query feature 4
Clear all pivot table fields with a Macro 2
Excel "Web Query" 3
edit web query 5
PERFORM ACTION ON HITTING ENTER 1

Back
Top