link b/w workbooks "format(now-1)"

[chabuca1]

Hello,

Can anyone fix this 1 line of code?
ActiveCell.FormulaR1C1 = "=Sum('C:\Temp\\[" & Format(Now - 1, "mm-dd-yy") & "]\Report" & Format(Now - 1, "mm-dd-yy")Shadow'!R11C6"
Thank you for any feedback!