VB & Excel Template Formatting

[JeremyLocke]

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

[SeaHag]

Don't know why its doing that..


There are a number of ways to save stuff....
Maybe its the wrong way I use."

Workbooks("stdcost.xls").Close saveChanges:=true