I am writing a macro that flips between 3 (already open - by another application) excel files/workbooks
problem is when I go to activate or select the workbooks I get subscript out of range
filename is exactly as needed
I think the problem is because the file is already open? (another instance of Excel) How do I get around this issue .