Hi,

I'm working in VFP6 and Excel 97. I'm creating Excel files that are overwritten each time the program is run. I'm using the SaveAs method with what I think are the appropriate parameters and I get a dialog box that comes up xxxx.xls already exists, do you want to overwrite? I don't want this behavior.

I'm trying to get the SaveAs method NOT to ask me if I want to overwrite an existing file. Below is the command with all the parameters. Am I missing something?


oXls.ActiveWorkbook.SaveAs(lcSaveFile,-4143, "", "", "False", "False" ,1 ,2)

The SaveAs Method uses the following parameters:
filename
fileformat = xlNormal (excel constant)
password = character string
writeResPassword = character string
ReadOnlyRecommended = either True or False (Is this passed as a character string?)
CreateBackup = True or False
AccessMode = xlShared, xlExclusive, or xlNoChange
Conflict Resolution = xlUserResolution, xlLocalSessionChange, or xlOtherSessionChanges

I've tried recording a macro to give me all the parameters but it stops at the CreateBackup parameter.

TIA,
Jacci