hi.

does this work for you?

eSAUK = "'\\corpusfs12\PROJECT-REPORTS\Pathfinder Reporting\Heather Lations\EMEA WEEKLY PHONE REPORT\2014\[EMEA SA UK.xlsx]"

ActiveCell.Formula = "=VLOOKUP(B3," & eSAUK & "Table1'!$A:$B,2,0)"