ExcelBanter - How do I remove data connections with VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I remove data connections with VBA (https://www.excelbanter.com/excel-programming/396743-how-do-i-remove-data-connections-vba.html)

vig

How do I remove data connections with VBA

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

Ron de Bruin

How do I remove data connections with VBA

Try this

For Each QTable In ActiveSheet.QueryTables
QTable.Delete
Next

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"vig" wrote in message ...
I want to remove data connections from my excel worksheet using visual basic
for applications. There are a great many data connections.

All times are GMT +1. The time now is 06:18 AM.