ExcelDna & NetOffice Conflict?

Apr 11, 2012 at 3:23 PM
Edited Apr 11, 2012 at 3:26 PM

I have at the top of a module

Imports ExcelDna.Integration    ' for xlCall
Imports NetOffice.ExcelApi ' for Workbook etc
Imports NetOffice.ExcelApi.Enums    ' for xlConstants

I want to be able to use code like ref.IsBroken here but get the message

                Error 7 Value of type 'NetOffice.VBIDEApi.Reference' cannot be converted to 'ExcelDna.Integration.Reference'. 

            For Each ref In ActiveWorkbook.VBProject.References


Just realised I should use Dim ref As NetOffice.VBIDEApi.Reference

Sorry - can I delete a post?