Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On application.....we have a OSuser() function.....
but i need run a macro and get a user from AD.......anyone knowns if s it possible???
or
another idea how can i do this???i need select a field based on user access and lock the aplication!!!!
tks
Sure, set a variable to the value =OSUser(), then refer to the variable in your macro.
ActiveDocument.Variables('vOSUser').GetContent.String
You may also be able to use Evaluate and the OSUser function directly and I think there is an equivilent function in VB Script, but I tend to use QlikView variables in these situations, because I don't have to look up the other functions.
Sure, set a variable to the value =OSUser(), then refer to the variable in your macro.
ActiveDocument.Variables('vOSUser').GetContent.String
You may also be able to use Evaluate and the OSUser function directly and I think there is an equivilent function in VB Script, but I tend to use QlikView variables in these situations, because I don't have to look up the other functions.
NMiller's way is working, if you want more VB Script based function check on documents but not all functions of VB Script are compatible with Qlikview.
NMiller,
i try to use that....but without success!!!!!
Any idea???
tks
Maybe your variable is set up incorrectly? Did you put an equals sign before OSUser?
=OSUser()
I've attached a simple example where it reads the OSUser from a variable and displays it in a MsgBox from a macro.
The problem was equal sign.....
tks a lot Miller