how to get users list by vba macro

[system]

Dim BOApp As busobj.Application
Call BOApp.Logon(“sgli”, “”, “svr320hp585”, “secEnterprise”) ’

but i don’t know how to next . who can help me ? thank you very much

can i user query like jsp code :
query(Select SI_ID, SI_NAME from CI_SYSTEMOBJECTS Where SI_KIND=‘User’) ?

---

lishuanggen (BOB member since 2007-03-16)

[system]

Try Julien Bras’ utility. You’ve got the code inside.

BOXI UserList & Group Extraction

Here is a little excel file with a bit of VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership. It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description. Platform: BO XI R2 / BOXI3.1 (it’s necessary to change the libs to fits XI3.1, s…

---

BO_Worker (BOB member since 2008-09-04)

[system]

greate ,thank you very much

---

lishuanggen (BOB member since 2007-03-16)

[system]

I want UserList & Group Extraction for BO.6.5.

Is it possible to extract all the groups and users of BO.6.5 using Vb.net or VBA

---

mrleokarthik (BOB member since 2008-10-09)