I have an outlook macro that wants to do a vlookup in an excel file. I keep getting the run time error "Object doesn't support this property or method".
In Excel, I use Application.VLookup and it works. I have tried many combinations but I cant find the one that works.
Please Login or Register to view this content.
Anyone know? Thanks very much
You need this.
Please Login or Register to view this content.
That gave me a different error - Unable to get the Vlookup property of the WorksheetFunction class
I just added this to my Outlook setup too....still trying
Microsoft Excel 14.0 Data Objects library. Go to Tools -> References.
Last edited by steve wilson; 12-04-2015 at 10:18 PM.
Solved, if your lookup value isnt found, you get a runtime error
works. So does xl.VLookup and WorksheetFunction.Vlookup.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks