This tutorial will help you in, allowing your Macro/VBA code to overwrite an existing Excel file.
This will allows you to do things like:
Export a weekly report to a specific file and overwrite that file each week.
Note: The technique in this tutorial does not require any confirmation in order to overwrite the file.
Add these two lines to any macro to allow them to overwrite a file without having the confirmation window appear:
This will allows you to do things like:
Export a weekly report to a specific file and overwrite that file each week.
Note: The technique in this tutorial does not require any confirmation in order to overwrite the file.
Overwrite A File Using VBA
Add these two lines to any macro to allow them to overwrite a file without having the confirmation window appear:
