Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? You could avoid the overwite by using FSO to explicitly check for the existence of the file to be overwitten first and delete it if it exits before calling the SaveAs method. -- Michael Harris Microsoft MVP Scripting -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Please ask follow-up questions via the original newsgroup thread. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple people accessing an Excel file from a server at once. | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |