on open, write to text file?

[aceee]

hey all.

I want to script, that whenever this excel file is opened, it adds:

the date, and the number 1. eg

02/04/2008 - 1

i want to it add this every time, to c:\openlog.txt

is this possible?

cheers

[antoka05]

Yes, it's possible. Add this code on 'ThisWorkbook'.
For example, right click on below tab with sheet name, choose view code and, in the left window (if not visible press Ctrl + R), double click on 'ThisWorkbook' and in the right window paste this code:

Please Login or Register  to view this content.

Regards,
Antonio

[aceee]

love you work!! thanks!!

[roaddog]

Newby here... Looking for some useful tips.

This info looks interesting. Is there a way to output the computer name of the computer that opened the file?


Thanks