Office Extensibility - Excel and PowerPoint

bwalker13

Hello,

I have a VB6 COM add-in project that adds footers to Word, Excel and Powerpoint (three versions of the .dll) when a document is checked out of WorkSite 8. The Word functionality mimics the macro code that IWov provides in the SDK, and it works correctly.

However, setting up the sink objects fails for both Excel and Powerpoint:

Public Sub AutoExec()

Dim objIManageExtensibility As iManO2K.iManageExtensibility
' An object used for extending the functionality of iManage Office 2002
' integration.

' Get the iManage O2K extensibility object.
Set objIManageExtensibility = _
Application.COMAddIns("iManO2K.AddinForExcel2000").Object ' works for Word, fails for Excel and PowerPoint

' Set up a sink to the extensibility object.
Set objSinkObject = New SinkObject
objSinkObject.SinkIManageExtensibility objIManageExtensibility

End Sub

When I check the properties of objIManageExtensibility for Word during debugging, I get values for the Context and CurrentMode. When I check the properties of objIManageExtensibility for Excel or PowerPoint, I get the following error:

Run-time error 9

Object Variable or With Block variable not set

Both the Excel and PowerPoint projects compile without error. Are there any known issues with the extensibility for Excel and PowerPoint? I am running WorkSite 8 with the latest hot-fixes.

Thanks.

--Ben

Migrateduser

Hi

Am encountering the same issue. Could you or anyone help?


Thanks

Jason