Check if data in a closed workbook is present in Access table

[aman1234]

Hi All

I am using the following line of code to extract the name of excel file that I would like to compare with Access table data.

Please Login or Register  to view this content.

Now i want to write VBA code to check sheet name "Summary" in that workbook and check if any of column D value matches with Access table tblmain field "Reference" values. If yes then change the status field of tblmain to "Yes".


Any help would be much appreciated.

Thanks