Hi, I am attempting to replace the hard typed filepath name in various formulas with the filepath as it appears in a cell.
For example rather than the below formula:
ActiveCell.FormulaR1C1 = _
"='I:\Finance\Reports\2022-2023\02 August 2022\[Consol Report Aug 22.xlsm]Retail'!R158C9"
being able to reference the file path as it is typed into another cell (say in cell C2 of ths sheet being worked in):
so that this file path name could be combined with the sheet name and cells in the formula.
Appreciate any assitance
For example rather than the below formula:
ActiveCell.FormulaR1C1 = _
"='I:\Finance\Reports\2022-2023\02 August 2022\[Consol Report Aug 22.xlsm]Retail'!R158C9"
being able to reference the file path as it is typed into another cell (say in cell C2 of ths sheet being worked in):
so that this file path name could be combined with the sheet name and cells in the formula.
Appreciate any assitance