Proper way to write file & sheet links in VBA

[sourav.iba18]

Dear all,

I am fairly new to Microsoft Excel VBA. Currently while making in a certain VBA project I am writing the following input but getting an error in return.

 ActiveCell.FormulaR1C1 = _
        "=IFERROR(VLOOKUP(RC4,'[D:\SDD Files\Reference File.xlsx]EBS Stock'!Table1[[Original Name(Plaza)]:[Zone Name]],2,0),"""")"

D:\SDD Files\Reference File.xlsx = File Name

EBS Stock = Sheet Name

Table1 = Automated generated table of data

Can anyone please tell me where am i going wrong here.. Thanks in advance.

Regards,

Sourav

[JBeaucaire]

THe brackets go around the filename, not the full path. That's the only edit I've made, can't test your formula as a whole:

ActiveCell.FormulaR1C1 = _
        "=IFERROR(VLOOKUP(RC4,'D:\SDD Files\[Reference File.xlsx]EBS Stock'!Table1[[Original Name(Plaza)]:[Zone Name]],2,0),"""")"