I am attempting to use an array to capture the row information based on the comparison match of policy numbers from the spreadsheet against the ADO table.
The object of this macro is to compare the policy numbers entered on the spreadsheet against the policy numbers in database table. Once they match, I want to get the value of a field called "Block No" for the matched policy numbers from the table.
Below are the code that I am using:
Any suggestions are welcomed. Thank you.Please Login or Register to view this content.
Bookmarks