Ok. Thanks Tim for the comments.

Dan,

In Excel native VBA, we can get another Excel session's Workbook object by
calling GetObject(pathname). Please refer to another post with the same
title you post. Peter gives an example code there.

If you need any future help on this, just let us know.


Best regards,
Ji Zhou
Microsoft Online Community Support Team