NOVELL FORUMS - GW: Library

NOVELL FORUMS - GW: Library http://forums.novell.com/ en Tue, 24 Nov 2009 17:30:39 GMT vBulletin 60 http://forums.novell.com/images/ca_serenity/misc/rss.jpg NOVELL FORUMS - GW: Library http://forums.novell.com/ Remove User from Distribution List via VBScript http://forums.novell.com/novell-product-support-forums/groupwise/version-independent-forums/gw-library/393060-remove-user-distribution-list-via-vbscript.html Tue, 17 Nov 2009 21:27:08 GMT I am having a hard time figuring this out. Here is what I have thus far. I know little of Novell or Groupwise. I am just trying to code this... I am having a hard time figuring this out.

Here is what I have thus far. I know little of Novell or Groupwise. I am just trying to code this because it was requested by a client. So far I have been able to figure out how to do lots with things with Groupwise and Novell. But removing a user from a Distribution List is giving me problems.

Code:

Set oGWAdmin = CreateObject("NovellGroupWareAdmin")

oGWAdmin.Connect ("\\server\VOL1\grpwise\nam_dom")

Set oDomain = oGWAdmin.ConnectedDomain

'Set oDomains = oGWAdmin.Domains

Set oUsers = oGWAdmin.Users

Set oUser = oUsers.ItemByDn("user.ou.oganization","tree_name")

Set oDList = oDomain.DistributionLists.Item("Distribution List Name","Post Office",oDomain)

oUser.MemberOf.Add oUser,0,oDList

msgbox "Done!"

The above code does not work .. apparently oUser.MemberOf.Add works but there is no "Remove" function.

Another thing I have found, was way too complex for me to understand. Here is the snipet of code I think could work but it is in vb.NET and I cannot code in that (which is why I am trying vbscript). Here is a link to that code, and below is the lines of code from that I think could work.. I just don't understand it all.

Code:

if mode = "remove" then 

                        set objgroup = getobject("LDAP://" & replace(objChildRS.fields("USGRPDN"),"/","\/"))

                        Set objUser = getobject("LDAP://" & replace(objChildRS.fields("USDN"),"/","\/"))

                        objGroup.Remove(objUser.AdsPath) 

                        objgroup.setinfo

                        wscript.echo "User-Removed"

                end if

I need something simple. I want to pass to the script the user object and the Distribution List object, and the script should remove the user from the Distribution List.

Thanks for any help here. ]]> GW: Library jxmiller http://forums.novell.com/novell-product-support-forums/groupwise/version-independent-forums/gw-library/393060-remove-user-distribution-list-via-vbscript.html GroupWise 7 sp3 DMS Excel 2003 Close http://forums.novell.com/novell-product-support-forums/groupwise/version-independent-forums/gw-library/392311-groupwise-7-sp3-dms-excel-2003-close.html Wed, 11 Nov 2009 21:15:17 GMT I'm having trouble with closing an Excel document from DMS. to close I
select File/Close. The user first reported that he would get a Run-time
424 error, object required. So I changed the Macro:

From:
Sub CloseMacro()
Call CloseFunction(False, False, EMPTY)
End Sub

To:
Sub CloseMacro()
Call CloseFunction(False, GetIsDirty(GetDocumentId(Workbooks.Item(1))),
Workbooks.Item(1))
End Sub

The error went away, but now close doesn't do anything. I select Close and
nothing happens. The only way to save and close the document is to select
the 'X' in the top right and close excel.

Any ideas?

Thanks

Brent Dastrup

]]> GW: Library brentrd http://forums.novell.com/novell-product-support-forums/groupwise/version-independent-forums/gw-library/392311-groupwise-7-sp3-dms-excel-2003-close.html