I have linked cells from one workbook to another using this formula, which works great. The only problem is everytime I open the workbook that has this link in it, a message pops up asking me to link the info, then when I click yes I have to choose the appropriate file in the network. Is there a way to make it automatically choose yes for me and then find the "SEPTEMBER04" file itself by using code or something?
Don’t have an account yet? Register yourself now and be a part of our community!