Vlookup with now formula

[Manjunath C]

Please suggest me a code for below formula
"=VLOOKUP(RC[-1],'["Reason for not uploading in UAT_" & Format(Now(), "DD-MMM-YYYY") & ."xlsm"]Sheet4'!C1,1,0)"

 

[pecoflyer]

Can't help you with code, but using NOW() will not help as it returns actual date AND time ( formatting will NOT affect the underlying value).
Use TODAY() instead

 

[p45cal]

possibly:

.FormulaR1C1 = "=VLOOKUP(RC[-1],'[Reason for not uploading in UAT_" & Format(Now(), "DD-MMM-YYYY") & ".xlsm]Sheet4'!C1,1,0)"