fb7894
06-26-2018, 08:39 AM
Here is an interesting problem...
I have a macro that creates a formula that will link to an external spreadsheet. The user will use a file picker to tell the macro the name of the path/workbook.
How can i set up a "template formula" in my workbook?
Example: I want to write a template formula like this
='myLinkedWB'!$H$43
then, the macro will change all my formulas to put in the valid path of the linked wb.
='C:\My File Path\[prototype v3.xlsx]Details'!$H$43
The problem is, Excel will not allow me to write formula #1 because it is invalid. Does anyone have a glamorous solution to this?
I have a macro that creates a formula that will link to an external spreadsheet. The user will use a file picker to tell the macro the name of the path/workbook.
How can i set up a "template formula" in my workbook?
Example: I want to write a template formula like this
='myLinkedWB'!$H$43
then, the macro will change all my formulas to put in the valid path of the linked wb.
='C:\My File Path\[prototype v3.xlsx]Details'!$H$43
The problem is, Excel will not allow me to write formula #1 because it is invalid. Does anyone have a glamorous solution to this?