Applying Sumproduct Formula to Cell via VBA Failing

[Ark68]

I am trying to find a VBA solution to using the countif function with a closed workbook. With reference to this post, I have attempted to to do this. My attempt is failing, with a #NAME error in the destination cell.
Here is the line of code I'm using to apply the formular to the cell.

.Cells(1, 30) = "=SUMPRODUCT(('D:\WSOP 2020\[permit_data.xlsx]Activity_Default'!$E2:$E2000=str_func)+0)"

Any suggestions on where I have gone wrong?

 

[Ark68]

str_func = "BaseballWMBARepMosquito (U10/U11)"

This value exists in cell E11, so I am expecting a return value of 1.

 

[Fluff]

Ok, add the extra quotes like

$E2:$E2000=""" & str_func & """)

 

[Ark68]

OK ... I have it working now. Thanks for your patience Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.