Microsoft Office Forums - View Single Post - Word create or open with VBA functionality?

Italophile · 01-28-2024, 06:06 AM

Please explain what you mean by "when I launch a document without the VBA template it does not have the functionality I desire."
You may find it helpful to read this article first: What is the relationship between a Microsoft Word document and its template? | ShaunaKelly.com

Please also explain your process of using the template. Typically, templates are stored in either the User Templates folder or the Workgroup Templates folder and accessed from File | New.

There is no need to use FSO to check if a file exists as VBA has a function for that. Just add the following into your project

Code:

Public Function FileExists(fullPath As String) As Boolean
  On Error GoTo NoFile
  FileExists = (Dir(fullPath, vbNormal) <> "")
  Exit Function
NoFile:
  FileExists = False
End Function