Hello, So i am fairly new at VBA but have been able to have a little success with writting some code. I've search online to see how I can write a macro in excel to import outlook appointments and see that it can be done. Basically, what I'm trying to do is import all appointments within the month, but be able to, as they are updated, to refresh it into excel. Once i got the code I know how to do a command button to refresh. I just need help with the code. I've been able to get a code, but it only does reocurring appointments and I need all appointments with the month listed.
This is what I got so far and I'm stuck as to where to go from here: Can anyone help me?

Sub importcalender()
Dim oOutlook As Outlook.Application
Dim oNmSpc As Outlook.Namespace
Dim oFldr As Outlook.MAPIFolder
Dim oItems As Outlook.AppointmentItem

Set oOutlook = New Outlook.Application
Set oNmSpc = oOutlook.GetNamespace("MAPI")
Set oFldr = oNmSpc.GetDefaultFolder(olFolderCalendar)
oItems = oFldr.Items

oItems.IncludeRecurrences = True
oItems.Sort "[Start]"

End Sub