Replace existing file

B

Brandi

I'm running a macro in access that then exports data into
various excel files. Is there any way the macro will
automatically tell access/excel to replace the existing
files. Every time it tries to save the data under that
same file name I have to click yes to replace the file.
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Restoring Overwritten Files 2
Word macro that can call cells out of Excel for a find and replace 0
Images are pixelated when saving to PDF 0
Autonumber field in Excel that behaves the same as Access 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Need Help with Macro Security 1
Error When Using TransferText in a Macro 1
Default local file location - folder redirection slowness 0

Top