Export to Excel prompts

  • Thread starter Thread starter J Shrimps, Jr.
  • Start date Start date
J

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?
 
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.
 
Thought so.
Thanks.

Ken Snell said:
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.
Click to expand...
 
Ken Snell said:
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.
Click to expand...

Wouldn't SetWarnings False do it?

Tom Lake
 
No, Tom, unfortunately SetWarnings only applies to the Access system
messages, such as action query confirmation prompts.
 
Steve, How about exporting to an excel file naming the
sheet. You are not prompted and the sheet is overwritten.

Chris
 
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.
 
Back
Top