Thats the error - [[Write Cell: The data you want to write “=VLOOKUP(B5,[fileabc 28-03-2020.xlsx]SQLExport!$A$2:$G$33000,1,0)” has a wrong format, or Excel is busy. If your data is a formula, make sure you use comma as parameters separator. Please check that you are not editing a value and that no dialog windows are opened.]]
and the formula is “=VLOOKUP(B5,[”+fileName+"]SQLExport!$A$2:$G$33000,1,0)"
and fileName = Path2.Split("".ToCharArray).Last