$$Excel-Macros$$ comparison between access forms to excel

hi folks, I have an excel sheet wherein column A contains EMP ID and column B contains EMP NAME. I also have an access database with multiple forms and each form contains this two fields also out of many fields. I want, if the EMP ID in form matches to column A in excel then highlight the cell.

Re: $$Excel-Macros$$ comparison between access forms to excel

Hi, Can you provide sample data. Regards, Swapnil. On Thu, Oct 13, 2011 at 5:48 PM, mrinal saha mris...@gmail.com wrote: hi folks, I have an excel sheet wherein column A contains EMP ID and column B contains EMP NAME. I also have an access database with multiple forms and each form

Re: $$Excel-Macros$$ comparison between access forms to excel

Hi, Pls find attached excel for solution. Click on button to run the macro. Regards, Swapnil. On Thu, Oct 13, 2011 at 6:18 PM, mrinal saha mris...@gmail.com wrote: Here are both access databse and an excel file. In access there is a object EMPDETAIL (form) contianing multiple forms.