Iam submitting some data from VB using ADO to Excel sheet.

like
rs.addnew
rs("sal")=formatcurrency(rss("sal"))

rs.update

every thing work fine but iin excel sheet in have text value for above
column(sal). Can any one help me How I can change data type so my excel
sheet have same datatype as in database

Thnx in Advance


---
Message posted from http://www.ExcelForum.com/