I have a Excel Template that I am trying to modify with commands like this:

obWorkSheet.Cells(10, "C").Value = txtCustomerName.text

That works great. The problem is I am loosing the formatting when I save the excel file.
obExcelApp.Save ("C:\INVOICE.XLS")

By loosing formatting I mean, the row heights are set back to default, and I can see the grid lines that were turned off in the original template.

How can I preserve my formatting settings????

Help??

Jeremy