Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activeworkbook connections.delete not working
Hi All,
Hopefully I explain this well......... I have a Excel 2007 spreadsheet which has a data connection to an Access 2007 table. In VB I do a Run Macro1 which does a RefreshAll and then removes the data connection. The disconnect is not working in automation but if I step thru it the disconnect happens. So, I don't understand why it does not work when run as automation but does work in debug mode. Sub Macro1() ' ActiveWorkbook.RefreshAll ' Call Macro2 ' End Sub Public Sub Macro2() ActiveWorkbook.Connections("Query from MS Access Database1").Delete End Sub thanks bobh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete Connections from Excel | Excel Programming | |||
Delete Columns/Row not working | Excel Discussion (Misc queries) | |||
Delete Row Sub not working | Excel Programming | |||
ActiveWorkbook.SendMail not working | Excel Programming | |||
ActiveWorkbook.Charts.Delete | Excel Programming |