If I have two workbooks open and I want to run a script in one workbook, which requires updating the other workbook. How do you call (write to) the already open second workbook- so that it doesn't attempt open the workbook a second time (which it can't as it is already open) ?
Thanks