vba code to populat word template in Access 2010

[graffjohn]

The following code worked fine for 5 years in MS Access 2003. My company converted to MS Office 2010 and the VBA MS Access code is now getting an error

The code is populating an MS Word template (.dot) with fields from a form. the line in BOLDED RED is giving the following error

"application-defined or object-defined error:"

So, I need the changes to the code so that VBA code will be compatable with MS Access 2010 and MS Word 2010

any insights would be appreciated

Thanks,
John

Here's the VBA code

'************************
' Print a general Letter
'************************


Dim objWord As Object
Dim HoldTemplateLocation As String
Dim Direc As String
Set Dbs = CurrentDb


Direc = "C:\MSWord_Lletters\"



' Open Microsoft Word

Set objWord = CreateObject("Word.Application")

objWord.Visible = True

objWord.Documents.Add Direc & "General letter.dot"



objWord.ActiveDocument.Bookmarks("X1ToodayName").R ange.Text = Forms![LookUpData]![ToodayName]

objWord.ActiveDocument.Bookmarks("X2ToodayDate").R ange.Text = Forms![LookUpData]![ToodayDate]


objWord.ActiveDocument.Bookmarks("X9Dearr").Range. Text = Forms![LookUpData]![AcctNum]

[ajetrumpet]

hmmm...

well the pool of info that the compiler is catching is:

.DOCUMENTS collection
.ADD method

so it's one of those two obviously. Perhaps .dot templates are allowed in the documents collection?

but looking at it closer, you are SURE this is right??

Direc = "C:\MSWord_Lletters\"

looks like there's 2 L's in your dir name?? upper and lower cases?? Perhaps some nice employee messed it up?

[ssanfu]

The following code worked fine for 5 years in MS Access 2003. My company converted to MS Office 2010 and the VBA MS Access code is now getting an error

1) Do you have these two lines at the top of every code page?

Option Compare Database
Option Explicit

2) Does the code compile without errors?

3) You might also check for broken (VBA) references. When you change versions of Access (or Office), the names of some of the dll's change. In A2K3, the reference library for Word is "Microsoft Word 11.0 Object Library"; in A2K10, the reference name might be "Microsoft Word 14.0 Object Library". Most reference names do not get updated when you convert from one version to another, which results in broken references.