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