Outlook objects with Office 2019 and runtime error -2147221233 Object could not be found

I have an excel workbook that contains rows of appointment information that I created many years ago and its been working fine. One of my users has been upgraded to Office 2019. I unfortunately do not have it and am having problems trying to troubleshoot why the code isn't working for them.

The flow of the tool is to filter a table based on a status field, and then delete all tasks and appointments from the filtered list. It then creates new tasks and appointments. As mentioned it has been working flawlessly and still does for users on office not using2019. I have used a copy of his file on my own pc and it runs without issues, so I know it isn't a case of deleted columns or something like that.

Here is the sub that is giving the runtime error. It appears as if that outlook object isn't available in office 2019. Anyone run into issues with the outlook objects and office 2019?

Please Login or Register  to view this content.

Here are screenshots of the error and debugging.
Untitled.png
Untitled1.png

In case you ask, here is the sub that creates the appointments

Please Login or Register  to view this content.

The error message clearly says 'An object could not be found' I think that tells it all.
The object i question is Mileage

Do you have a reference set to the Outlook object library? If not, have you declared the olAppointmentItem and olTaskItem constants?

2019 does use a different reference, but it should be forwards compatible (but not backwards). Anyway, do you have a reference set?

If you don't have a reference set to the Outlook object library, your code shouldn't really work on 2016 either since it would be creating the wrong kind of items. The code you have is a curious mix of what you would typically use with late binding, and with early binding.

Anyway, does that user have any issues with Outlook itself? The error message is one that sometimes appears with Outlook when there is a profile issue.

MAC doesn't use the same libraries. Does the MAC have Outlook installed?

I suggest you read here: http://www.rondebruin.nl/mac.htm

The reference will upgrade itself when opened on 2019. That will be fine, as long as you don't then need to share the same workbook with other users. Personally, I would suggest late binding the code and doing away with the reference altogether.

Like rorya says the reference updates automatically but does the 2019 version include Outlook and is it installed?

You believe, well, even if this person is in another province this person can TELL YOU if it's installed, he/she got mail?

Well someone with MAC and Office 2019 will have to look into it for you, sorry

Why do you say MAC? He is running windows 10. I mentioned the VM because I don't want to upgrade my PC to office 2019. I run win10 with office 2016

THIS IS WHY I SAY MAC you first text in #1

The flow of the tool is to filter a table based on a status field, and then delete all tasks and appointments from the filtered list. It then creates new tasks and appointments. As mentioned it has been working flawlessly and still does for users on office not using 2019. I have used a copy of his file on my own pc and it runs without issues, so I know it isn't a case of deleted columns or something like that.

Here is the sub that is giving the runtime error. It appears as if that outlook object isn't available in office 2019. Anyone run into issues with the outlook objects and office 2019?

And Office 2019 is NOT a Windows version

Office 2019 is a Windows and Mac version.

Not that I know of

2016 or 365 and 365 can be used on both platforms cause it's webbased

https://products.office.com/en/get-s...th-office-2019

And 365 is not web based - you have confused it with Office online.

Okay, still 2019 is not windows version
But that’s all besides the point the fact remains the OP has an issue with the code on a Mac

No he doesn't, as he's already stated; and yes, Office 2019 is a Windows version too.

Okay, stand corrected. That's what you get when you don't read your articles on time