Hi all,<BR><BR>I have this option which exports recordet values to Excel.<BR>It&#039s just that I have this 4 fields which I have to multiply it&#039s value by 1000. how do I detect the fields name? <BR><BR>I&#039ve tried the codes below but unsuccessful.<BR>Note. The 4 fields are- Curr_spend, Profit, Bid_Value, Total<BR><BR>So I check for a field first say Total.<BR><BR> For i = 0 To rs.fields.Count-3 <BR> if rs.Fields(i+1).Name="Total"<BR> xlWorksheet.Cells(iRow,i+1).Value = rs.fields(i+1)*1000<BR> else<BR> xlWorksheet.Cells(iRow,i+1).Value = rs.fields(i+1)<BR> Next <BR> iRow = iRow + 1 <BR> <BR>The error is the object does not support the Name property.<BR>Pls help...i&#039m lost :)