cFichier = "C:\FolderName\FileName.XLS" * this command sets the variable to "C:\FolderNameFileName.XLS.csv" cNewFichier = JUSTPATH(cFichier) + JUSTFNAME(cFichier) + ".csv" * this command sets the variable to "C:\FolderName\FileName.CSV" cNewFichier = FORCEEXT(cFichier, "CSV")2. If you want Excel to save the file as a certain type (i.e. CSV, XML, TXT), use the FileFormat parameter.
* this command saves the file as xlCSV .SaveAs(cNewFichier, 6)3. If you want to close a document without being prompted to save changes, use the SaveChanges parameter.
* this command closes the document without any prompts to save .Close(0)Frank