HI ALL,
i don't know how to set the font and cell format to export excel, i use CreateObject("Excel.Application") and can output to excel but format .........

Question 1. i want to set the font center, but how can i do?......

        Sheet.Range("N" & iRow).Font.Size = 9
        Sheet.Range("N" & iRow).Font.Bold = True
        Sheet.Range("N" & iRow).Font.Name = "Times New Roman"

------------------------------------------------------------------------
Question 2. i want to Merge cells, and display the word , but i already merge , word disapper?

Sheet.Range("B9", "B10").Merge()
Sheet.Range("B10").Value = "Item Code"

-------------------------------------------------------------------------
Question 3. if i want to Merge cells after, the Merge cells change to gray , how can i do?
--------------------------------------------------------------------------
Question 4. Have vb.net to do a draw box , mean like crystal report box line........ or must only use line not box function?

exsheet.range(cells,cells).Borders.LineStyle=1