View Single Post
 
Old 07-18-2014, 04:19 AM
KSReynolds KSReynolds is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Oct 2013
Posts: 7
KSReynolds is on a distinguished road
Default 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.
Reply With Quote