Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Excel97 SaveAs Method question
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement