Hi Experts,
I am looking for a macro that will do the things mentioned below
If first entire row of 1.xls matches with first entire row of Error.xlsx then do nothing Else A msg box should popup & that msgbox should not be closed without putting paasword & assume paasword would be 123456
Plz note first entire row may be different as shown in the sample file & i may put the first entire row data of error.xlsx to second entire row so plz let me know the changes for that also, so in future i can change it by myself & as per my needs
Note:
Macro will be placed in a macro.xlsm There are 3 files(Macro.xlsm,1.xls & Error.xlsx) & all three files are located in a different path so the path should be hardcoded in the macro for that 2 files
sheet name can be anything
If condition matched then do nothing Else msgbox with paasword
-
- Banned
- Posts: 253
- Joined: 22 Apr 2020, 17:24
If condition matched then do nothing Else msgbox with paasword
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78541
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: If condition matched then do nothing Else msgbox with paasword
OK, that's enough.
Best wishes,
Hans
Hans