Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |