Hi all,

Dim xl As New Object
Dim wb As Excel.Workbook
Dim sh As Excel.Worksheet
xl = CreateObject("excel.application")

wb = xl.Workbooks.Open("c:\file.xls")

sh = wb.Worksheets(1)
sh.Name = "Bench-Marking DATABASE"

With sh
.Cells(2, 1).Value = "T"
.Cells(2, 2).Value = "D"
.Cells(2, 3).Value = "L"
.Cells(2, 4).Value = "T"
.Cells(2, 5).Value = "A"
.Cells(2, 6).Value = "C"
End With

wb.save()

i managed to save the file, but i always get this pop up window asking me to whether to save the file or not,
is there a way i can do it, wihout having to see the small window.

take care