Prev: Permission denied Code: 800A0046
Next: VBScript for Windows Updates (advert)
From: SunRace on 7 Feb 2006 13:20
Hello,

When I am trying to use objUser.SetPassword = strPSW - strPSW is being
picked up from Excel cell.
I am getting "object dose not support this property or method" error. But
when I define objUser.SetPassword = "Password" it works.
Basically I have worked out random password generation in excel and I want
to pickup the randomly generated and unique passwords from excel itself
My user creation script works with objUser.SetPassword = "Password" method
but that gives me repetition in passwords. Could some one help me with the
right use of objUser.SetPassword object so that I can use random values
with it?

Thanks & Regards
Suraj Jadhav


From: Richard Mueller on 7 Feb 2006 17:01
SunRace wrote:

> When I am trying to use objUser.SetPassword = strPSW - strPSW is being
> picked up from Excel cell.
> I am getting "object dose not support this property or method" error. But
> when I define objUser.SetPassword = "Password" it works.
> Basically I have worked out random password generation in excel and I want
> to pickup the randomly generated and unique passwords from excel itself
> My user creation script works with objUser.SetPassword = "Password" method
> but that gives me repetition in passwords. Could some one help me with the
> right use of objUser.SetPassword object so that I can use random values
> with it?
>
> Thanks & Regards
> Suraj Jadhav

Hi,

Is it possible your passwords are numbers that need to be converted to
strings with the CStr function? I assume you retrieve the value with code
similar to:

strPSW = CStr(objSheet.Cells(j, k).Value)

Of course the passwords must satisfy domain constraints on length,
complexity, etc. However, you error message sounds more like objUser does
not refer to a user object. Or, perhaps in your context you lack
permissions.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net


From: SunRace on 9 Feb 2006 01:08
Hello,

Solved - actually I was using wrong code... I mean I used
objUser.SetPassword strPSW) and it worked!

"Richard Mueller" <rlmueller-NOSPAM(a)ameritech.NOSPAM.net> wrote in message
news:ucOkFIDLGHA.2812(a)TK2MSFTNGP14.phx.gbl...
> SunRace wrote:
>
>> When I am trying to use objUser.SetPassword = strPSW - strPSW is being
>> picked up from Excel cell.
>> I am getting "object dose not support this property or method" error. But
>> when I define objUser.SetPassword = "Password" it works.
>> Basically I have worked out random password generation in excel and I
>> want to pickup the randomly generated and unique passwords from excel
>> itself
>> My user creation script works with objUser.SetPassword = "Password"
>> method but that gives me repetition in passwords. Could some one help me
>> with the right use of objUser.SetPassword object so that I can use
>> random values with it?
>>
>> Thanks & Regards
>> Suraj Jadhav
>
> Hi,
>
> Is it possible your passwords are numbers that need to be converted to
> strings with the CStr function? I assume you retrieve the value with code
> similar to:
>
> strPSW = CStr(objSheet.Cells(j, k).Value)
>
> Of course the passwords must satisfy domain constraints on length,
> complexity, etc. However, you error message sounds more like objUser does
> not refer to a user object. Or, perhaps in your context you lack
> permissions.
>
> --
> Richard
> Microsoft MVP Scripting and ADSI
> Hilltop Lab - http://www.rlmueller.net
>


 | 
Pages: 1
Prev: Permission denied Code: 800A0046
Next: VBScript for Windows Updates (advert)