It's not the methode to save the created workbook but it's about the trick
to create a workbook* with a specific name* *without* saving it.
You'd like to see the code, it has nothing to do with this isue because this
routine creates the export before creating the workbook it self.
But anyway:
Hello,
Maybe, use « SaveAs » instead of « Save » ?
Anyway, can you post your code ?
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Stilgar
Envoyé : vendredi 8 juillet 2011 11:10
À : excel-macros@googlegroups.com
Objet :
Try this
Workbook.SaveAs FileName
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Stilgar
Sent: Friday, July 08, 2011 2:40 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Filename for unsaved workbook
Hello,
I wrote a script to
