Simple question - is it possible to open the Outlook calendar directly from a button in Excel without opening Outlook, ?

[chazrab]

If not, then is it possible to create an Outlook type calendar in Excel with the same features, i.e.
1. create any message in a square(1 day of the month)
2. attach a notification reminder to it with a time and a sound alert
3. Postpone, add, edit and delete buttons

Thanks for anyone's help on this
cr

 

[Logit]

Option Explicit

Sub ShowCal()

' Note! Before you can use these example you must set a reference to the Outlook Object Library.

Dim olApp As Object ' Outlook.Application
Set olApp = CreateObject("Outlook.Application")
olApp.session.GetDefaultFolder(olFolderCalendar).Display

End Sub

 

[chazrab]

Hi logit - thanks for replying back. It works great - is there any way to make the Outlook calendar stay on top (i.e., as in Showmodal = false for userforms) , once open in Excel ?

Thanks, cr

 

[Logit]

I haven't been able to locate a COMMAND SWITCH that would instruct Outlook Calendar to remain on top of other windows.
There are a number of add-ons that will assist with this requirement.

This add-on is only about 20 Kb in size :

Download OnTopper - MajorGeeks


This add-on is about 10 Mb in size :

Actual Window Manager - Download Center - Actual Tools


Note: I have not utilized any of these add-ons or any other. You will need to decide on your own if this is the path you want to take.