Hi All
I have a userform where when the user clicks on the browse button then filepath gets stored in the textbox as below:
Please see attached the excel workbook. Now in that file , the first sheetname will always be "Summary". So i want VBA code that will check if the data in Column D in sheet "Summary" is present in field "Reference" of Access table "tblliterature" . if its present then check in the Summary sheet , which corresponding fields out of "Withdrawn","Obsolete" and "Updated" stores "Y" .
If Withdrawn column value is "Y" then change the status of corresponding record of tblliteraure to "Withdrawn"
If Obsolete column value is "Y" then change the status of corresponding record of tblliteraure to "Obsolete"
If Updated column value is "Y" then change the status of corresponding record of tblliteraure to "Updated"
Any help would be much appreciated.
Thanks
Bookmarks