Hello. I have a workbook with a click event. The click event opens another
workbook and runs a procedure in the newly opened workbook.

I would like to read the contents of of Sheet1, cell A1 in the file that
houses the click event, and be able to use that variable in the code in the
workbook that the click event opened. Can this be done?? Thanks.