VBA works in Excel 2013 but not Excel 2010

[KungFu Keyboard]

Hi there,

The following code works on Excel 2013 but wont work on Excel 2010:

Sub GetFromOutlook()


Dim OutlookApp As Outlook.Application
Dim OutlookNamespace As Namespace
Dim Folder As MAPIFolder
Dim OutlookRecipient As Outlook.Recipient
Dim OutlookMail As Variant
Dim I As Integer


Set OutlookApp = New Outlook.Application
Set OutlookNamespace = OutlookApp.GetNamespace("MAPI")
Set OutlookRecipient = OutlookNamespace.CreateRecipient("ey@globalloadcontrol.com")
Set Folder = OutlookNamespace.GetDefaultFolder(olFolderInbox).Folders("Irregularity Reports")


I = 1


For Each OutlookMail In Folder.Items
        If OutlookMail.ReceivedTime >= Range("From_date").Value Then
        Range("eMail_subject").Offset(I, 0).Value = OutlookMail.Subject
        Range("eMail_date").Offset(I, 0).Value = OutlookMail.ReceivedTime
        Range("eMail_sender").Offset(I, 0).Value = OutlookMail.SenderName
        Range("eMail_text").Offset(I, 0).Value = OutlookMail.Body
        
        I = I + 1
    End If
Next OutlookMail


Set Folder = Nothing
Set OutlookNamespace = Nothing
Set OutlookApp = Nothing
Set OutlookRecipient = Nothing

End Sub

I am getting compile errors.

What's the best way around this?

Regards,
Bernard

 

[Joe4]

Are you sure that you have selected all the correct Library References on the other system?
On the one that it works on, go to VB Editor, and go to Tools -> References, and note all the selected Libraries. Then do the same on the other system, and make sure that similar libraries are selected (the version numbers may be slightly different).

If you still get compile errors, please let us know which lines it indicates are problematic.

 

[KungFu Keyboard]

You're right - it was a version issue. I had to uncheck the missing object library.15 and check the correct object library.14 for that version of excel

thanks!

 

[Joe4]

You are welcome.