get the named items in excel workbook

[sush026]

hi,

how can i get a list of the named items in a excel workbook (I am using excel 2007 Professional Plus). I need to search if a particular named item exists in the workbook and then i have to set the particular cell with "that" named item with a value. Please tell me how can i do this using C#

Thanks,
Sush

 

[xld]

I'll give you it with VBA, you do the translation

    On Error Resume Next
    Set rng = Range("myName")
    On Error Goto 0
    If Not rng Is Nothing Then
        rng.Value = "myValue"
    End If

 

[Andrew Poulsom]

I don't know about C~, but here is a VBA example:

Sub Test()
    Dim sName As String
    Dim nName As Name
    sName = "TheName"
    On Error Resume Next
    Set nName = ActiveWorkbook.Names(sName)
    If Err = 0 Then
        Evaluate(nName.RefersTo).Parent.Range(sName).Value = 123
    Else
        Err.Clear
    End If
    On Error GoTo 0
End Sub