Hi,
i have below code attached to a button in access form.
How can i amend same such that when it export into the excel:
the header first row(A1 to J1) is bold and calibri font 14; row A2 to A5 - bold and A1 TO J5 get border line.
i have below code attached to a button in access form.
How can i amend same such that when it export into the excel:
the header first row(A1 to J1) is bold and calibri font 14; row A2 to A5 - bold and A1 TO J5 get border line.
Code:
Dim outputStats As String
outputStats = CurrentProject.Path & "\Product_Stats_" & Format(Date, "yyyyMMdd") & Format(Time, "hhmmss") & "_" & Environ("USERNAME") & ".xls"
DoCmd.OutputTo acOutputReport, "Products", _
acSpreadsheetTypeExcel19, , True
End Sub