i do face an excel which several sheets, all refering to other files but looking exactly the same. i finished now one country, i still need to do so for all the others. so what i need to do is simply now replace all "CAN"-characters with "US", now i have all references to other files changed correctly (and it is easy to do so with a macro).
problem is, that whenever i change a reference, a dialog box popps up, where i need to choose the file too (even tough in the excel file the reference string itself is like it shoud be).
anyone has an idea, how to handle that pop up dialog box with vba? maybe using sendkeys and the file name? (which i can adapt for each sheet easily within the cba code). i have never automatically filled out and confirmed a dialog box inside excel.
thank you a lot!
problem is, that whenever i change a reference, a dialog box popps up, where i need to choose the file too (even tough in the excel file the reference string itself is like it shoud be).
anyone has an idea, how to handle that pop up dialog box with vba? maybe using sendkeys and the file name? (which i can adapt for each sheet easily within the cba code). i have never automatically filled out and confirmed a dialog box inside excel.
thank you a lot!
