Pasting Excel Chart into PowerPoint

J

Jan

When pasting a Microsoft Excel object into a PowerPoint presentation as an
embedded object (i.e. a chart as a chart not as an image), the in-place
editing fails if an instance of Excel (with a Vb.Net Add-In which handles
Excel.Application events installed) is open. It fails with a generic add-in
problem. The failure does not occur when Excel is closed or after the
instance from which the object was posted is closed. Vb.Net Add-Ins which
does not handle Excel.Application events seems to be working fine! Please
help!!

Error: "Microsoft cannot start the application required to open this object"

My Connect Class:
Using Addhandler instead of the WithEvents keyword resulted in the same
error...
Public Class Connect
Implements Extensibility.IDTExtensibility2
Dim WithEvents applicationObject As Excel.Application
Dim addInInstance As Object
Public Sub OnConnection(ByVal application As Object, ByVal connectMode As
Extensibility.ext_ConnectMode, ByVal addInInst As Object, ByRef custom As
System.Array) Implements Extensibility.IDTExtensibility2.OnConnection
Try
MsgBox("OnConnection")
applicationObject = application
addInInstance = addInInst
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Private Sub applicationObject_WorkbookOpen(ByVal Wb As Excel.Workbook)
Handles applicationObject.WorkbookOpen
Try
MsgBox(Wb.Name)
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Public Sub OnBeginShutdown(ByRef custom As System.Array) Implements
Extensibility.IDTExtensibility2.OnBeginShutdown
End Sub
Public Sub OnAddInsUpdate(ByRef custom As System.Array) Implements
Extensibility.IDTExtensibility2.OnAddInsUpdate
End Sub
Public Sub OnStartupComplete(ByRef custom As System.Array) Implements
Extensibility.IDTExtensibility2.OnStartupComplete
End Sub
Public Sub OnDisconnection(ByVal RemoveMode As
Extensibility.ext_DisconnectMode, ByRef custom As System.Array) Implements
Extensibility.IDTExtensibility2.OnDisconnection
End Sub
End Class
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top