Forex-Forex
05-11-2018, 02:58 AM
Hi Community
I have attached a VBA that works in Excel 2016 but not in Excel/Outlook 2013 that I require.
The purpose is to pull emails from Outlook 2013 to Excel 2013.
When I run it, I am getting an error saying:
Compile Error:
Can't find project or library
Sub Get_Emails (olfdStart As Outlook.MAPIFolder, Date1)
Under References - VBA Project
Missing: Microsoft Outlook 16.0 Object Library.
At work we use Excel and Outlook 2013 and I cannot upgrade to say 2016.
Can any suggest or amend the file attached please as my VBA knowledge is limited.
I have seen some posts on this topic but do not fully understand it.
Any help will be most welcome.
Thanks
I have attached a VBA that works in Excel 2016 but not in Excel/Outlook 2013 that I require.
The purpose is to pull emails from Outlook 2013 to Excel 2013.
When I run it, I am getting an error saying:
Compile Error:
Can't find project or library
Sub Get_Emails (olfdStart As Outlook.MAPIFolder, Date1)
Under References - VBA Project
Missing: Microsoft Outlook 16.0 Object Library.
At work we use Excel and Outlook 2013 and I cannot upgrade to say 2016.
Can any suggest or amend the file attached please as my VBA knowledge is limited.
I have seen some posts on this topic but do not fully understand it.
Any help will be most welcome.
Thanks