Hi Steph

could you tell me how do you open the workbook that resides in the server,
it would be so helpfully for me if you send me the code please, i really need
it

thanks
my email addres is:

"Steph" wrote:

Hello. I have a workbook with a single sheet and a click event on that
sheet. The click event opens a different workbook that resides on the
server and runs a procedure that is housed in the newly opened workbook.

When the newly opened macro is executed, I need to know where the
click-event originated from. I have the file owners name in cell A1. I
would like to read the contents of cell A1 (the sheet name will vary with
different files) 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.

So basically the click event fires, and the newly opened workbook can pop up
a message box that says "this workbook was opened by <var" where <var is
the value in Cell A1 of the click-event workbook.

Possible??