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. ='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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

link form to changing workbook in folder

Thread starter kriminaal
Start date Jul 10, 2018
Tags

file folder form link workbook

kriminaal

New Member

Jul 10, 2018

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.

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