Question related to dynamic file name

[rkb1510]

I have one code which is using formula, in below format
dstws.Range("A2").FormulaR1C1 = "=INDEX([obj_3_Table.csv]obj_3_Table!R2C6:R" & lastRowSrc & "C6, MATCH(RC[3],[obj_3_Table.csv]obj_3_Table!R2C1:R" & lastRowSrc & "C1, 0))"

but I want to generalize this formula depending on file name and sheet name something like below
dstws.Range("A2").FormulaR1C1 = "=INDEX(" & [srcwb.Name] & srcsheetanme & "!R2C6:R" & lastRowSrc & "C6, "MATCH(RC[3]," & [srcwb.Name] & srcsheetanme & "!R2C1:R" & lastRowSrc & "C1,0))"

but when i try this it is keep giving me error or not working. To debug i have try to print formula after it set, and found out formula is not taking correct names

 

[rkb1510]

Formula in below format is working just have to add missing square brackets before and after srcwb.Name in order match it with actual formula

formulastr = "=INDEX(" & srcwb.Name & srcsheetanme & "!R2C6:R" & lastRowSrc & "C6, " & _
"MATCH(RC[3]," & srcwb.Name & srcsheetanme & "!R2C1:R" & lastRowSrc & "C1,0))"