I need some assistance with developing a macro (or VBA code).
The following describes the desired process:
1. Open a Word document (i.e., my template).
-- This document shall contain a button that executes the macro/VBA
-- The document also contains some/any text
2. Upon clicking the "Execute Macro" button, the currently open Word document is replicated. However, it only shall replicate the content and format. It shall NOT include the >> macro << button.
3. The newly created Word document (w/o the macro button) shall be saved in a specified/default folder on the C drive.
4. The newly created Word document must have a specified/default file naming convention (e.g., "TestDocument.doc").
Note: Ideally, the lines of code shall be as minimal as possible.
** Break **
Assuming the above four steps work, I may also want to consider automatically overwriting an existing Word document (with the same file name in the same subfolder) automatically. That is, I should not be prompted to confirm "Replace". Ideally, this may need to be a separate function/process that can be turned on/off.
Please see attached Word document that contains the sample/template.
Does anyone know how to design the above process efficiently (i.e., few lines of code)?
Thank you in advance,