Delete file before macro runs

[rml]

I have a macro that outputs an xls file to a folder on my hardrive. The
macro fires off dalily at a specific time. Everything works fine the first
time. I would like to be able to delete the previous file just before the
the macro runs. That way, it does not stop or prompt me for a over wright or
file already exists.

Thanks.

 

[Steve Schapel]

Rml,

Sorry, as far as I know it is not possible to perform file manipulations
with an Access macro. You will need to use a VBA procedure for this,
using the Kill method.