Sub Get_Existing_Outlook_Instance()
Dim objOutlook As Outlook.Application
' Gets the existing instance (if Outlook is already open) regardless of early or late binding
On Error Resume Next
Set objOutlook = GetObject(, "Outlook.Application")
If objOutlook Is Nothing Then
Debug.Print "Outlook is not open, getting a new instance"
Set objOutlook = New Outlook.Application
End If
Set objOutlook = Nothing
End Sub
Microsift VBA Early vs. Late Binding Example
Private Sub Early_vs_Late_Binding_Example()
#Const LATEBINDING = False
#If LATEBINDING Then
Dim objOutlook As Object
Set objOutlook = CreateObject("Outlook.Application")
#Else
' NOTE! Early binding requires a typelib reference. In the VBE click Tools -> References
' and make sure that "Microsoft Outlook xx.x Object Library" is selected
Dim objOutlook As Outlook.Application
Set objOutlook = New Outlook.Application
#End If
Set objOutlook = Nothing
End Sub
Move Ubuntu Unity Launcher to the Bottom of the Screen
gsettings set com.canonical.Unity.Launcher launcher-position Bottom
To reset to the left side:
gsettings set com.canonical.Unity.Launcher launcher-position Left
To reset to the left side:
gsettings set com.canonical.Unity.Launcher launcher-position Left
Changing the window placement in Ubuntu
To see the current setting:
dconf read /org/compiz/profiles/unity/plugins/place/mode
To update the setting:
dconf write /org/compiz/profiles/unity/plugins/place/mode 1
(Try different values to understand the behavior.)
dconf read /org/compiz/profiles/unity/plugins/place/mode
To update the setting:
dconf write /org/compiz/profiles/unity/plugins/place/mode 1
(Try different values to understand the behavior.)
Subscribe to:
Posts (Atom)