Hi all, I've got a file from where I execute the code (wb1) and other file where the outputs come from (wb2). My intention is to get the outputs without linking both workbooks. When I have both of them opened I get the workbook path of wb2 by a macro and, as I know the name of the cells in the second, would like to link the path of wb2 to formulas using the named cells of wb2 but don't know how.

For instance, C:\Users\dvb_24\wb2.xlsm would be the path
the formula is sumproduct(d*f) (d and f are named cells of wb2)

How can I link both in order to put a formula in wb1 (including names of wb2) and get the output?