Hi-
I am setting up workbook(A) (a collection of summary figures) that will reference 4 other workbooks. There will be about 3900 references (individual cells) in workbook(A) to these 4 other workbooks. I'm thinking ahead to a time when they might move one of the files to another drive and I don't want this to become a nightmare to maintain.
I'll bet someone has asked this before so I tried searching through the posts but perhaps did not use the correct phrase.
What do you guys think would be the best way to do this? Can I create 4 variables for each of the workbooks and use that instead of the file path? (if so, what do you Dim a file location as?) or there is probably some other option I haven't thought of?
Thank you -
I am setting up workbook(A) (a collection of summary figures) that will reference 4 other workbooks. There will be about 3900 references (individual cells) in workbook(A) to these 4 other workbooks. I'm thinking ahead to a time when they might move one of the files to another drive and I don't want this to become a nightmare to maintain.
I'll bet someone has asked this before so I tried searching through the posts but perhaps did not use the correct phrase.
What do you guys think would be the best way to do this? Can I create 4 variables for each of the workbooks and use that instead of the file path? (if so, what do you Dim a file location as?) or there is probably some other option I haven't thought of?
Thank you -
