VBA Update - Declaring Worksheets and Ranges

Hi all,

I am a novice programmer and recently an update of windows and office has caused some issues. So it was working on VBA6 and Office 2007, but not on VBA 7.1 / Office 2016.

This sub is designed to grab the last active reminder in Outlook, and then find the corresponding customer in an excel database, then go to that cell.

It now fails on declaring the worksheet "User type not defined" which I got around by declaring 'ws' as an object instead of a worksheet... not sure if this helps or not though.

Then Rng now seems to not find anything, nor will it go to the found cell...

Please Login or Register  to view this content.

Hi xlnitwit,

I thought that, but I copied all the references we had previously. And then when it failed, I scrolled through to find anything that may hold the reference to excel... so unless it is not obvious, I don't think it would be that.

I found the below article, which mentions at the bottom referencing access as an object and "Some applications don't recognize individual Microsoft Access object types" and was wondering if this might be similar to my experience with referencing excel from outlook???

https://msdn.microsoft.com/en-us/vba...ring-variables