wordapp.ActiveDocument.SaveAs Not Working
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.
|