Setting value of a named cell in a worksheet 1

[adalger]

Hi, all. I have an issue.

I have a worksheet in excel. I've defined names for certain cells. These names follow a defined format to make the programming easy and clear (to me, at least). Too bad it doesn't work.

Here's what I have:

    Dim str As String
    Dim rst As Recordset
    Dim fld As Field
    Dim wksht as Excel.Worksheet

    Set rst = CurrentDb.OpenRecordset("qrySIR_CSR")
    rst.MoveLast
    rst.MoveFirst

' a bunch of stuff that correctly results in wksht
' being a valid reference to the sheet I want to modify

    For Each fld In rst.Fields
        str = rst.Name & "." & fld.Name & ".c"
        [COLOR=red]? What goes here? (1)[/color]
        
    Next fld

(1) What I need is a way to say "The cell with the name in str gets the value of fld." How do I refer to a cell in Excel by name? Is this possible? Or do I have to maintain a long list of cell row/column identifiers?

Thanks for any insight.

-- Rob

 

[CautionMP]

adalger,
I think your looking for:
[tt]wksht.Range(str) = fld.Value[/tt]

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[adalger]

Yes, that's it exactly. Thank you!