Opening word doc from VBA

Question

I have a subroutine in MS Access that opens a specific word doc file. The gist of the code is

Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim filepath as String

'Open Word
Set wrdApp = CreateObject("Word.Application")
wrdApp.Visible = True

filepath = CurrentProject.Path & "\Prospect Profiles\Account Profile Form.doc"

'Open the file
Set wrdDoc = wrdApp.Documents.Open(filepath)

So here's the kicker - The subroutine works for all but one of our employees. We're all on the same Citrix environment, and we all have the same version of Access and Word. For this user, the subroutine does not give an error - it smiply opens a blank instance of ms word but it never opens the word doc file. What gives?

Can that employee open Account Profile Form.doc manually once Word is running? — HansUp
From within that VBA procedure does Dir(filepath) return the file name? — HansUp

Ben G Ben G · Accepted Answer · 2013-03-27T19:22:08

Aha! It turns out that this user had made a copy of an older version of our database front end and he wasn't accessing our current, updated version. Thanks for all the help y'all!

Opening word doc from VBA

1 Answers