This is great, except the quote is in the cell. Our users don't want the quote.
Thanks,
Jerry
>
>If you want excel to consider the contents of a cell as char data, simply prepend a single quote
>ie
>
>oSheet.ActiveSheet.Cells(lnRow, 2).Value = ['] + rtrim(mycursor.field2)
>