macro userID, ntname...

[#1]

hi everybody!

I extracted a table from Qlik to a formatted Excel's sheet...

I need to rename the excel file with the name of the user who launch the macro, but i've a problem...

I control the accesses with NTNAME and DOMAINSID and the command "temp.UderId" don't work...(last week I controlled the accesses with username and psw and this command worked right...)

I dont't want that who see the extracted file can read the NTNAME, because I need total security cause to the file extracted will saved in the common server of my company...

I just want a command similar to "UserId" that not display confidential id or psw...

sorry for my english...

thanks who will reply!!

Alessandro

[Anonymous · Accepted solution]

Alessandro,
NTNAME, if you use it in section access, can be retrieved by function OSUSer().

[rwunderlich]

Alessandro,

Try:

userid = ActiveDocument.Evaluate("OsUser()")

-Rob

[#4]

Thanks to all fot the replies!!!