See if this change works:

"\\SB1VMHOM02\home$\OveryA\Desktop\SCSM Report\Reports" & Format(Now, "YYYY-MM-DD") & ".docm", _