Hi all, first time posting. I have a master tracking document (WB1) that needs to return values from an external workbook (WB2) even when WB2 is closed. I have done this successfully using workbook cell formulas.
However, WB2 has to be moved around within a shared folder structure. I'm trying to figure out how to find WB2 no matter where it resides within that structure. I've tried using "IFERROR" and "IF" statements to check each path but (yes, unbelievably) I end up exhausting the 8,192 character limit for workbook cell formulas. Why doesn't "OR" work for this issue?
A VB solution would not only hurt my newbie brain, but apparently you can't access a closed external document in VB. Opening WB2 first would work, but I've tried to keep this problem simple with only one external document... there are actually over a hundred I need to link to the master file. Opening all of them just to update my file would be a last resort.
Thank you for your time, I really appreciate it.
However, WB2 has to be moved around within a shared folder structure. I'm trying to figure out how to find WB2 no matter where it resides within that structure. I've tried using "IFERROR" and "IF" statements to check each path but (yes, unbelievably) I end up exhausting the 8,192 character limit for workbook cell formulas. Why doesn't "OR" work for this issue?
A VB solution would not only hurt my newbie brain, but apparently you can't access a closed external document in VB. Opening WB2 first would work, but I've tried to keep this problem simple with only one external document... there are actually over a hundred I need to link to the master file. Opening all of them just to update my file would be a last resort.
Thank you for your time, I really appreciate it.
