_Excel_RangeWrite Formula with variable

[SkysLastChance]

I have been trying to figure this out longer then I would like to admit. I am betting that I am missing something super simple. 

#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookNew($oExcel)

$vPath = "'J:\Temporary Files\FolderName\FileName.xlsx''!$A:$B,2,0))'"

 _Excel_RangeWrite($oWorkBook, Default, '=IF(D2=D1,"",VLOOKUP(D2,''J:\Temporary Files\FolderName\FileName.xlsx''!$A:$B,2,0))', "A1", False) ;Line 1
 _Excel_RangeWrite($oWorkBook, Default, '=IF(D2=D1,"",VLOOKUP(D2,' & $vPath, "A2", False) ;Line 2
 
ConsoleWrite("'=IF(D2=D1,"",VLOOKUP(D2,''J:\Temporary Files\FolderName\FileName.xlsx''!$A:$B,2,0))'" & @CRLF)
ConsoleWrite("'=IF(D2=D1,"",VLOOKUP(D2,'" & $vPath & @CRLF)

Why is line 1 writing but line 2 is not? 

Any suggestion to lead me in the right direction is appreciated. 

 

[SkysLastChance]

Figured it out.

#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookNew($oExcel)

$vPath = "'J:\Temporary Files\FolderName\FileName.xlsx'!$A:$B,2,0))"

_Excel_RangeWrite($oWorkBook, Default, '=IF(D2=D1,"",VLOOKUP(D2,''J:\Temporary Files\FolderName\FileName.xlsx''!$A:$B,2,0))', "A3", False) ;Line 1
_Excel_RangeWrite($oWorkBook, Default, '=IF(D2=D1,"",VLOOKUP(D2,' & $vPath, "A4", False) ;Line 2