Never mind - I took a different route. I use DIR to test for the file
name -if it exists, I add a number to it to make a new file name.

Ed

On Jan 26, 7:54*am, Ed from AZ wrote:
I'm making my first forays into Access with code. *As part of a data
export sub, I create an instance of Excel and add a new workbook. *I
create the name of the workbook with the date in it. *As I'm testing
this, Excel keeps giving me a warning that a workbook already exists.
(All this is in Excel and Access 2003, by the way.)

How can I write the code in Access to allow Excel to overwrite the
previous file in the SaveAs?

Ed