Do Index Match Match to pull data from multiple worbooks

Hi, I want to do a Macro that performs an "index match match" to pull data from multiple workbooks that are closed and on Dropbox.

The names of the workbooks depend on the value of a cell and the value of an input box. The value of the input box also influences the path.

I'm getting error '1004' when I run it. I've tried using WorksheetFunction.index and WorksheetFunction.match as well as ExecuteExcel4Macro but I get error on both.

Code is below:

HTML Code: 

The ExecuteExcel4Macro is commented because I'm either using WorksheetFunction or ExecuteExcel4Macro but wanted to include both since I don't know which one I should use and what's the error in the code.

Thanks,
Luis

1) Change path separator from / to \
2)

Please Login or Register  to view this content.

Too many double quotes before first PathFileSheet.
Cell reference for ExecuteExcel4Macro must be R1C1 notation.

Hi, I tried changing the / to \ but had the same error, also eliminating the extra double quotes. I'll link a thread here as reference as I used that macro (which works) as a base for this one. The other macro uses "/" for the path.

https://www.excelforum.com/excel-programming-vba-macros/1321244-pulling-data-from-another-workbook-which-name-depends-on-cell.html

I really appreciate your help.

Thanks!

Let's see what message comes up.

Please Login or Register  to view this content.