Analysis for Office 2.1 Logoff via VBA

Since version 2.1 Analysis for Office is now finally a VBA command to log out of the current system.

So far is nothing in the help file, but it is called in the SCN Forum under "Whats new in Analysis for Office 2.1".

The command is:

1
2
3

Public Sub Logoff()
  Call Application.Run("SAPLogoff",Parameter)
End Sub

Parameter:

• True: With this value, the connection is restarted the system
• False: With this value the connection will not restart the system

Result:

• 0: faulty execution
• 1: Successful execution

These posts might also be interesting:

• Analysis for Office Logoff
• Analysis for Office: Best Practice Connection
• Settings for the Analysis for Office Plug-in
• Enable Analysis for Office Addin

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.