View Single Post
 
Old 08-15-2014, 09:16 AM
KSReynolds KSReynolds is offline Windows 7 32bit Office 2003
Novice
 
Join Date: Oct 2013
Posts: 7
KSReynolds is on a distinguished road
Default My Code

This is my code from Access:

Dim myfilename As String
myfilename = ReportDir & LabNumber & "_" & ItemNumber & "_" & CATEGORY & ".doc"
Dim mypassword As String
mypassword = DecryptPIN(DLookup("PIN_NUMBER", "ANALYST", "FULL_NAME='" & ana_txt & "'"))
'save to temp directory
wordapp.ActiveDocument.SaveAs filename:=myfilename, WritePassword:=mypassword
wordapp.ActiveDocument.Close
Reply With Quote