I have created some code that imports a file selected by a user, performs some analysis, and then saves specified tabs into a new workbook. When the new workbook is opened a Data Connection Warning appears. I have checked the following and I am officially stumped:
1.) There are no connections listed within the Workbook Connections Window.
2.) There are no macros / code saved within the new workbook.
3.) I have run the following code and get no results.
Public Sub removeDataConnections()
If ActiveWorkbook.Connections.Count > 0 Then
For i = 1 To ActiveWorkbook.Connections.Count
ActiveWorkbook.Connections.Item(1).delete
Next i
Else
MsgBox ActiveWorkbook.Connections.Count
End If
End Sub
Somebody please help me before I go crazy trying to figure this out!
Bookmarks