How do I remove data connections with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to remove data connections from my excel worksheet using visual basic
for applications. There are a great many data connections.
 
Try this

For Each QTable In ActiveSheet.QueryTables
QTable.Delete
Next
 
You must log in or register to reply here.

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

Copy/Paste and remove blanks VBA 0
ADO retrieval from close workbook-data type issue 2
Refreshing NON-embedded External Data Connections 1
VBA - Freeze data in external data range 3
Excel 2007 connection via oledbconnection 2
Excel ODBC driver created table/inserted data lost on application 1
help to understand 'querytable' 1
How much slower is Excel VBA compared to Visual Basic .net? 2

Back
Top