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
|