excel to open outlook calendar on specific date

[Luis FR]

Hello gurus! I've been looking around for a while and even though I was able to find some VBA scripts to open outlook calendar from excel, I need to find a way to open outlook's calendar on a given date that is feed from a defined cell.
I don't know if that can be done.

regards!

 

[Logit]

.
This is one method :

Option Explicit

Public RunWhen As Double

'**************************************Application.OnTime**********************
Sub ScheduleMacro()
'This schedules the next run time
RunWhen = Sheet1.Range("A1").Value
Application.OnTime EarliestTime:=RunWhen, Procedure:="MyMacro", Schedule:=True
End Sub
Sub MyMacro()
''''''''''''''''''''''''
' Your code here
MsgBox "Hi"
''''''''''''''''''''''''
End Sub
Sub CancelSchedule()
'Cancels the scheduled event
RunWhen = Sheet1.Range("A1").Value
On Error Resume Next
Application.OnTime EarliestTime:=RunWhen, Procedure:="MyMacro", Schedule:=False
End Sub