you have a line like:

set xls = createobject("excel.application")
(Or its equivalent)

xls.displayalerts = false
'your code to save/overwrite
xls.displayalerts = true

(Do you actually need the .application in xls.application.quit??)

Olivia Towery wrote:

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

--

Dave Peterson