Document Editing Problems

Open a Word Document as a New Copy from Access VBA

Maira MehtabMaira Mehtab Nov 14, 2026 868 views

Question details

Open a Word document from Access VBA as an editable, independent copy.

Open a Word Document as a New Copy from Access VBA
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.
Before you start

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.

Solution 1Recommended

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.

1
Save the source as a template

In Word, open the source document, select File > Save As, and choose Word Template (*.dotx). Save it in a location accessible to Access.

2
Add the Access VBA code

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

3
Edit and save the new document

Run the procedure from Access. In the new Word document, make changes and use File > Save As to choose a filename and location.

Create a new Word document from a template
Keep the template unchanged: Documents.Add creates a new document based on the template; it does not open the template itself for editing. Use a macro-enabled template format if the template must contain VBA macros.
Free Microsoft Office alternative

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.

Open and edit documents in a familiar word-processing interfaceCompatible with Microsoft Word DOC and DOCX formatsSave a separate copy of a document for editingFree and lightweight for everyday office work
microsoft office alternative - wps office

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.