Hi,
I have run into a problem. I have two files e.g BRE2 master.xlsx & BRE2.xlsx. I open the second file from the first. All variables are correctly set (masterName, SheetNames, sourceFileName, TestVar1), I used the debugger to check this. When Workbooks(sourceFileName).Activate is called I...