Application.Evaluate returns Error2015, working in Excel Sheet

Dear all,

I am fairly new to VBA's Application.Evaluate Method.

Here goes my code:

Please Login or Register  to view this content.

formula evaluates to

"Vlookup("CLCR";'W:\Path1\SubPath2\[UnopenedExternalExcelSheet.xlsb]country pairing'!$A$2:$C$65109;3;FALSE)"

If I plug this into an ExcelSheet, adding a "=" and removing the opening and closing quotes ("), the vlookup works and i get the desired (and expected) result.

However, as stated above, in code (VBA), i get error 2015.

What is going wrong here?


Thank you!

Try replacing the semicolons with commas.

You would have to put the formula into a cell, I think.

To mark a thread as solved, please do not edit the title. Instead, please select Thread Tools from the menu link above and mark this thread as SOLVED. I've done it for you this time.