Word 2010, Access 2010. I have VBA code that successfully opens up Word, merges my document with my template, but then does not save the file with the values I am supplying. This IS working for my 200 users, but it is not working on my workstation. I am wondering if there is some setting in Word that I need to change so that this code will work.

'This is not working, the file is not saving


wordapp.ActiveDocument.SaveAs ReportDir & LabNumber & "_" & ItemNumber & "_" & CATEGORY & ".doc", , , , , DecryptPIN(DLookup("PIN_NUMBER", "ANALYST", "FULL_NAME='" & ana_txt & "'"))
wordapp.ActiveDocument.Close

The file itself wants to save as the words that appear in my heading.

All of my values show as valid in the immediate window in Access. What am I missing here? I admit I am cross-posting, UtterAccess had no replies for me. And that is unheard of.

Thank you.

This is unlikely to be a Word or VBA issue, since it is working for your other users. Rather, it is more likely to be an issue with network permissions and/or what the ReportDir variable is being populated with.

PS: For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184. You need to provide links between the two sites, so anyone looking at the issue on either can take into account what has been said on the other.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]