Hi
I have opened a word application and used Access to create a report.
Ihave saved the report and now I want to exit word.
So far I have found .close which will close the file but the blank word application still appears on the screen.
Here is the tail end of my sub
strDocName = strBusManName & "-Summary-" & Format(Now(), "dd-mm-yy")
strDocName = strFilePath & strDocName
ActiveDocument.SaveAs (strDocName)
ActiveDocument.Close
' Set the Word Object to nothing to free resources
Set WordObj = Nothing
DoCmd.Hourglass False
How do I make VBA shutdown Word?
I have opened a word application and used Access to create a report.
Ihave saved the report and now I want to exit word.
So far I have found .close which will close the file but the blank word application still appears on the screen.
Here is the tail end of my sub
strDocName = strBusManName & "-Summary-" & Format(Now(), "dd-mm-yy")
strDocName = strFilePath & strDocName
ActiveDocument.SaveAs (strDocName)
ActiveDocument.Close
' Set the Word Object to nothing to free resources
Set WordObj = Nothing
DoCmd.Hourglass False
How do I make VBA shutdown Word?