Check the Double Quotation "
in the Date
Try with this expression
"\kotvs003\KOT\Works\Poldat\Controlling\PBI\MPZW\InventoryPBI\Material Usage Per Month\Material Usage Per Month"+now.AddMonths(-1).ToString("MMyyyy")+".xlsx"
Check out this thread
Regards
Gokul