Vlookup from ThisWorkbook

[hutch@edge.net]

Greetings, Gurus.

I'm trying to vlookup into a workbook, starting in the selected cell, and lookup in a range in ThisWorkbook, (the workbook containing the macro). For some reason, it always returns a #N/A. I think it's a simple matter of how I have ThisWorkbook referenced, (apostrophe/bracket, or whatever). Here is the code I am trying to use to do a vlookup into 3 consecutive cells across a row:

    Application.DisplayAlerts = False
    ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC1,'[ThisWorkbook]BO Response'!C1:C10,8,FALSE)"
    ActiveCell.Offset(0, 1).FormulaR1C1 = _
        "=VLOOKUP(RC1,'[ThisWorkbook]BO Response'!C1:C10,9,FALSE)"
    ActiveCell.Offset(0, 2).FormulaR1C1 = _
        "=VLOOKUP(RC1,'[ThisWorkbook]BO Response'!C1:C10,10,FALSE)"
    Application.DisplayAlerts = True

Thanks in advance for any help you can offer.