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))