Recording changes in the file

[betousouza]

I have to record somewhere in a sheet when the file is saved which computer did it.
Someone knows how to do it?

[Mark@Work]

I can't think of a way to do this without using a bit of VBA code.

However it should be possible by using the Environ() function in VBA

Press Alt and F11 to open up the VBA editor
type environ into the help search and look at the example supplied.

One of the environ options is COMPUTERNAME

Mark.

[Mark@Work]

To create a user defined function to return the computer name
Record a very simple macro then edit the macro code to read as follows:

Please Login or Register  to view this content.

Finally type into the required cell =ComputerName()
This should give you what you want.

Mark.