Is it possible to have my form link to a folder whereas the workbook changes?
The folder will hold a workbook that I will place there to have my form get data from.
I will delete this workbook and replace with another when needed.
Not sure if this would work or not.
If this was my source file calling up data from B15.
How would I change the formula that the link won't be broken but always call on whatever file is placed in that source file?
thanks
The folder will hold a workbook that I will place there to have my form get data from.
I will delete this workbook and replace with another when needed.
Not sure if this would work or not.
Code:
='C:\Users\Owner\Desktop\source\[IFCC-testlinks.xlsm]order'!$B$15
If this was my source file calling up data from B15.
How would I change the formula that the link won't be broken but always call on whatever file is placed in that source file?
thanks