Just to follow up on this, I have found the following information elsewhere (thanks 'Barry'!) and intend to try out the suggested solution:
Quote:
Dynamic Named Ranges have to be "Calculated" hence the need for the workbook to be open. A workbook can only be calculated when open.
However, how can you get around this. There is a kluge way around it. What you need to do is when the target workbook is open that before it closes it puts the address of the named range into a cell as a fixed value.
You should then be able to reference that address and retrieve the value and use it to in place of the dynamic named range.
|