Excel 2003 VBA: ranges and formulas

I am attempting to write a macro using a named range and a formula. The named range is on one worksheet already. The line of code for the formula looks like this:
ActiveCell.Formula = “=vlookup(e4,’neworders.xls’!items,3,False)-f4”
I am dealing with the folloing range: Range(“[neworders.xls]!items”)
Any help, as this doesn’t seem to compile.