Open a Word Document as a New Copy from Access VBA
Question details
Open a Word document from Access VBA as an editable, independent copy.

- Product
- Microsoft Access and Microsoft Word
- Device & OS
- not provided
- Scenario
- An Access VBA procedure opens a shared Word document for users to edit and save under their own filenames.
- Observed behavior
- Each user needs an editable document that can be saved separately without changing the original.
Confirm that Microsoft Word is installed and that Access can reach the source file. Decide whether users should start with an unsaved document or with a copy already saved at a separate path.
Create a new Word document from a template
Use a Word template when each user should start with a new, unsaved document based on the same content.
In Word, open the source document, select File > Save As, and choose Word Template (*.dotx). Save it in a location accessible to Access.
In Access, open the VBA editor and add this procedure to a module. Replace the template path with your own: Sub OpenNewWordDocument() Dim WordApp As Object Dim WordDoc As Object Set WordApp = CreateObject("Word.Application") Set WordDoc = WordApp.Documents.Add("C:\Templates\ClientLabels.dotx") WordApp.Visible = True End Sub
Run the procedure from Access. In the new Word document, make changes and use File > Save As to choose a filename and location.

Copy the Word file before opening it from Access
Use this option when you need a separate file to exist on disk before the user begins editing.
Edit Word Documents with WPS Writer
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Word documents. Its format compatibility makes it easy to move existing files to WPS Writer. The Access VBA automation described above still requires Microsoft Word.

Frequently Asked Questions
How do I create a new document from a Word template in Access VBA?
Create a Word application object, then call Documents.Add with the template path, such as WordApp.Documents.Add("C:\Templates\ClientLabels.dotx"). Set WordApp.Visible to True so the user can edit the new document.
Will editing the new document change the template?
No. Documents.Add creates a new, unsaved document based on the template. Use File > Save As in Word to save the new document under its own name.
Can I open a separate copy without converting the source to a template?
Yes. Use VBA FileCopy to copy the source DOCX to a unique destination path, then pass that destination path to WordApp.Documents.Open.
Is opening the source as read-only the same as creating a copy?
No. Read-only mode protects the original from being saved over directly, but it does not create a separate file at the start. A user can generally edit the document and use File > Save As to save changes elsewhere.




