Export to Excel prompts

[J Shrimps, Jr.]

I have 30 or more queries that
have to be exported every month.
Since the data in the underlying
tables is new, I want to overwrite
last month's queries.
I can easily create a macro that
exports all the queries to the
same folder every time,
but I am prompted with the
"X:\Data\Spreadsheets\Region1\YadaYada.xls
already exits. Do you want to overwrite?"

Yes, in fact I do, AND STOP ASKING ME!!!
Is there a way to turn this message off?

 

[Ken Snell [MVP]]

Not via a macro, no. You would need to use VBA code to delete the current
file so that the export won't find the file already exists.

 

[J Shrimps, Jr.]

Thought so.
Thanks.

Not via a macro, no. You would need to use VBA code to delete the current
file so that the export won't find the file already exists.

 

[Tom Lake]

Not via a macro, no. You would need to use VBA code to delete the current
file so that the export won't find the file already exists.

Wouldn't SetWarnings False do it?

Tom Lake

 

[Steve Schapel]

No, Tom, unfortunately SetWarnings only applies to the Access system
messages, such as action query confirmation prompts.

 

[Chris Reveille]

Steve, How about exporting to an excel file naming the
sheet. You are not prompted and the sheet is overwritten.

Chris

 

[Ken Snell [MVP]]

You are correct that this does not ask about overwriting the sheet (and thus
the file). However, using the Range argument in an export is not a
documented feature for ACCESS, so one runs the risk that it won't work in
future updates or versions.