Help With Excel

Verb

Can anyone help please.

I currently use the following function to put a date on the sheets that get print out in work.

=TODAY()

Does anyone know of a similar function that will allow me to attach the UserName of whoever prints.

Thanks

Vomityspice

You can do it with some VBA.

googler

I googled 'insert user name excel' and this was third on the list...

http://vbaexpress.com/kb/getarticle.php?kb_id=768

victor2

Not quite as easy, but a simple bit of code can do it if you are happy creating a VB "macro"...
Put this into a Visual Basic editor session within the spreadsheet:
Function GetUserName()
GetUserName = Application.UserName
End Function

Then in the spreadsheet itself, just use =GetUserName() where you want the currently logged in user's name.

Verb

Hi all, thanks for the replys.
Look at both and tried victor2's. But when i do it all it adds to the sheet that I print is the word Name.

Can anyone add to this please.

PhilCo_2

You will need to make sure all users have their username filled in in Options.

googler

PhilCo wrote: »

You will need to make sure all users have their username filled in in Options.

Doesn't this presume that each user is using their own PC?

Lil306

googler wrote: »

Doesn't this presume that each user is using their own PC?

Yup

Those settings are stored in c:\docs settings\app data IIRC

doverswot

Verb wrote: »

Hi all, thanks for the replys.
Look at both and tried victor2's. But when i do it all it adds to the sheet that I print is the word Name.

Can anyone add to this please.

As stated, victor2's solution relies on the data being populated in Excel, which isn't reliable, so what you want to get is the logged on user. Googler's link will do thiis, however there is simpler way using the vba environ function which can be used to return the operating system Environment Variables, and one of the environemnt Variables is the Windows Username.

Function GetUserName()
GetUserName = Environ("USERNAME")
End Function

To see the other Environemnt variable you can return using this method, o to a command prompt and type SET. Any of the variables to the left of the "=" can be returned using this method by change the name in quotes.