Hello all,

I am still new to writing my own scripts and VBA in general. I'm working in Excel 2007, I have written a macro to run a vlookup from another spreadsheet and have tried to include the file path so that it can automatically find it when the macro is run. However, when I run the macro, the Update Value window opens and forces me to choose the file path manually for each cell. Below is the script I have written, I have searched several forums and tried a few different options but not having any success. I fear its something small, like a bracket or a quote, but have tried multiple combinations. Any insight would be most appreciated.
The spreadsheet name is "Sale Extract Template", the tab name is "Data"

Range("A2").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC2, 'F:\Administration\Templates\[Sale Extract Template.xlsx]Data'!R2C1:R1203C96, 43, FALSE)"

Thanks,
Katie