Delete file before macro runs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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