Feb 08 2023 09:22 AM
I created and Excel addin in Visual Studio VB that seems to break OLE between Excel and Word. The problem is caused by a Application.WorkbookOpen sub in ThisAddIn.vb. Select an Excel range and paste it into Word as a Worksheet Object. It is now impossible to edit the Worksheet object and Word gives an "item cannot be found" error (see image). After a few minutes Excel gives an OLE Error (see image)
The problem can be recreated by starting a new Visual Studio Project using the "Excel VSTO Add-in" template. Add the Application.WorkbookOpen sub to ThisAddIn.vb (see code) and run the add-in.
Public Class ThisAddIn
Private Sub ThisAddIn_Startup() Handles Me.Startup
End Sub
Private Sub ThisAddIn_Shutdown() Handles Me.Shutdown
End Sub
Private Sub Application_WorkbookOpen(Wb As Workbook) Handles Application.WorkbookOpen
End Sub
End Class
Is this a bug or am I doing something wrong?