Hi:
I am using an Excel object to save data from a VB Application. The application has to be run unattended coz it collects the data from the database and save it to Excel file every midnight. The problem is it gives a message box "A file names xyz.xls already exists in this location. Do you want to replace it?"
which i do not want coz it is supposed to be unattended. Following line of code I am using
oSheet.Saveas "xyz.xls"
Is there a way out ??? thanks in advace...
I am using an Excel object to save data from a VB Application. The application has to be run unattended coz it collects the data from the database and save it to Excel file every midnight. The problem is it gives a message box "A file names xyz.xls already exists in this location. Do you want to replace it?"
which i do not want coz it is supposed to be unattended. Following line of code I am using
oSheet.Saveas "xyz.xls"
Is there a way out ??? thanks in advace...