Question: how to set date format in excel using vb.net?
Answer: Dim oExcel As Object.
Dim oBook As Object.
Dim oSheet As Object.
Set oExcel = CreateObject("Excel. Application")
Set oBook = oExcel. Workbooks. Add.
With oSheet.
For i = 0 To objRs. Fields. Count - 1.
oSheet. Cells(1, i + 1). Value = Trim(CStr(objRs. Fields(i). Name))