Hi. is it possible to create code in VBA or as a macro that will close an aplication other than access?
I currently have open access and i have a button that when you press it it
opens a report
converts it to PDF
Saves the PDF
Opens a email client within access with the saved PDF attached
Everything works great now but the PDF that has been created is left open in front of the database......
Is it possible that VBA can close this? rather like the oposite code to:
Dim stAppName As String
stAppName = "C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe"
Call Shell(stAppName, 1)