Apr 11, 2012 at 4:23 PM
Edited Apr 11, 2012 at 4: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?