Excel 2007 disconnect data from web

[johnny52]

How do you disconnect from " Data " "From Web"

I currently have a live feed for my excel spreadsheet from the website......but when I'm done I'd like to stop the connection.

Thanks

 

[chuckchuckit]

To remove one connection:

Dim TheConnectionName As String
TheConnectionName = objWBConnect.Name
ActiveWorkbook.CONNECTIONS(TheConnectionName).Delete

Or you can use this to remove one connection, or all connections:

Dim TheConnectionName As String
For Each objWBConnect In ThisWorkbook.CONNECTIONS
    TheConnectionName = objWBConnect.Name
    ActiveWorkbook.CONNECTIONS(TheConnectionName).Delete
Next objWBConnect

You can monitor what happens by looking at Menu, Data, Connections, before and after.

 

[johnny52]

Thanks

I'll give that a try !