AnkitGupta
01-30-2012, 08:31 PM
Hi,
I am new to VBA and have been asked to make an "Audit Trial" in excel using VBA. The basic idea is -
I have 2 excel sheets (A.xls & B.xls). Whenever, someone opens A.xls, the user's name and time should get saved in B.xls.
Excel A.xls is also a shared workbook.
Could anyone please help me out with this.
Thanks in advance.
Regards,
Ankit
I am new to VBA and have been asked to make an "Audit Trial" in excel using VBA. The basic idea is -
I have 2 excel sheets (A.xls & B.xls). Whenever, someone opens A.xls, the user's name and time should get saved in B.xls.
Excel A.xls is also a shared workbook.
Could anyone please help me out with this.
Thanks in advance.
Regards,
Ankit