You can follow the discussion on Page update: Copy a range from closed workbooks (ADO) without having to leave a comment. Cool, huh? Just enter your email address in the form here below and you’re all set.