如何使用Microsoft.Office.Interop在Visual Studio中引用Excel NamedRange

我正在使用ExcelDNA从VBA转换到VB.NET,以实现Excel加载项。在我的代码中,我试图通过NamedRange的名称来引用它(就像在VBA中一样),以设置name的“RefereTo”属性。但是,我得到一个错误,它无法将我提供的名称转换为整数。错误:从字符串“MyNamedRangeName”到类型“Integer”的转换无效。

在下面的代码中,您可以看到错误发生的位置和原因。

Imports Microsoft.Office.Interop
Imports ExcelDna.Integration
Public Class Class1
    Sub SetReferToProperty()
        Dim ap As Excel.Application = ExcelDnaUtil.Application
        Dim wb as Excel.Workbook = ap.ActiveWorkbook

        'This is where the error occurs. Apparently, I can't (?) refer to    
        'the NamedRange by it's name. I need to use it's index.
        wb.Names("MyNamedRangeName").RefersTo = 0

        'If I use the Index instead (assume it's 1) it will work, but I
        'want to use the name instead - not the index.
        wb.Names(1).RefersTo = 0
    End Sub
End Class