Excel Server Object won't overwrite
I am using the CreateObject("Excel.Application") to create a workbook from
three separate tables in a sql db. This works great and compiles three
separate sheets to one workbook. The following lines name and add the
workbook to the directory:
fName = "" & strfile & ".xls"
xls.ActiveWorkbook.SaveAs server.MapPath(".") & "\" & fName
xls.Application.Quit
What do I need to add to make the object overwrite the existing file?
--
Olivia Towery
|