Word Automation | Microsoft Access Sample Code

Function for using Word Automation

Do you need to interact with a word document from within your Access Databse? Word Automation is a very powerful technique where you can communicate with an Word document from within VBA code in your Access Project. This allows you to do some very powerful things, such as populating an existing document with data from your database, taking advantage of Word documents you've already setup, dump data into a document and format it and wide variety of other uses. The function below shows a very simple example of how to interact with Word from within your Access Application.

Public Function doWordAutomation() On Error GoTo doWordAutomationErr Dim objWordDoc As Word.Document Dim objWord As Word.Application Dim sDocument As String sDocument = Application.CurrentProject.Path & "\MyNewWordFile.doc" Set objWord = CreateObject("Word.Application") Set objWordDoc = objWord.Documents.Open(Application.CurrentProject.Path & "\MyExistingWordFile.doc") If FileExists(sDocument) Then Kill sDocument End If objWordDoc.SaveAS sDocument With objWordDoc.Bookmarks If .Exists("YourBookMarkName") Then .Item("YourBookMarkName").Range.Text = "your value" End If End With objWordDoc.Save objWordDoc.Close doWordAutomationExit: Exit Function doWordAutomationErr: MsgBox Err.Description, vbOKOnly, Err.Source & ":" & Err.Number Resume doWordAutomationExit End Function

The Microsoft Access Word Automation Database is a sample database that shows you how to implement Word automation inside your own Access Database.

Please note that this is a template database. If it doesn't meet your needs 100% and you're unable to customize it yourself, let us know and we'll provide a quote to develop the customizations you need to get you exactly what you want in your Access Word Automation Database System.

Main Menu

Word Automation Form

Main Menu Form

Word Automation - Modern Look (Access 2010/2013)

Previous Next

Live Demonstration: To experience a more interactive and personalized demonstration of this WSI template, we invite you to contact WSI and schedule a live demonstration with one of our team members. This opportunity allows you to engage directly with us, either as an alternative to or in conjunction with downloading and exploring the demo version of the template at your leisure. Please note that downloading Microsoft Office files, including Microsoft Access database files, might trigger a security warning on your computer. To avoid this and get a comprehensive overview, you have the option of viewing the template through a virtual meeting on Teams or Zoom with a WSI representative.
Once you purchase the database template, you will receive the full version of the database in a standard Access Database file. The purchased database will have full access to the database window, all design objects, the visual basic project code, and you will be able to modify or add to the design in any way you wish (this does not apply to the run-time/compiled versions). If you lack the time to integrate this database into your system, please Contact Us and we will be glad to help with your integration process. If you like the basics of what you see in the database, but need enhancements to make the system functional for your business, please Contact Us and we will develop a quote for you to implement the additional features and enhancements that you require.

$24.99 - this allows you to use this database template however you wish within your organization.

$49.99 for unlimited developer use - this allows you to use this database template however you wish for any applications you develop and distribute.