This formula works as is, provided the workbook is open. Is there a way to use the following code regardless if the referenced workbook is open or closed?
I appreciate any assistance. Thank you in advance.Range("o27").Select ActiveCell.FormulaR1C1 = _ "=SUMIF([projectpoints.xls]exportprojectpointstoexcel!R2C2:R5C2,""= _ December"",[projectpoints.xls]exportprojectpointstoexcel!R2C7:R5C7)"