Can another set of eyes take a lookat the following code and provide insight as to why its bombing out. Basically it loops through the records found until end of file and I would like it to assign it to column A beginning at row 2 - whatever the number of records is found ... I know that because of this i have to add a counter (denoted by I) and therefore cannot write a static statement due to multiple records in the record set. So I tried creating a string but the errror I'm getting is when I try executing the string (assuming its when I .value the thing) ... I think I'm missing a step here guys ... help? It tells me Error Object Required: 'objWorksheet2.cells('
Yep totally missing a step ... ideas please?
objRecordset.Open "Select * FROM [Data$] Where LE<=#05/31/2008#", _
objConnection, adOpenStatic, adLockOptimistic, adCmdText
Set objWorksheet2 = objExcel.Sheets("PROJECTSAFTERQUERY")
Do Until objRecordset.EOF
'copy record to different spreadsheet
cellvalueLE = "objWorksheet2.cells(" & i & ",1)"
cellvalueLE.value = objRecordset.Fields.Item("LE")
i = i + 1