VBA script during load?

[james]

Good evening,

is it possible to use a vba script during a load?

I have some code that returns all Active Dirctory namse and who is assigned to said AD.

ANy ideas?

[Anonymous]

Hi James,

Yes, it's possible to run VB Script during script load. There are certain restrictions for accessing the contents of the QlikView document, mainly targetting objects under ActiveDocument. For accessing external sources it should be fine though. Not sure if there are better ways to query an AD using some kind of ODBC driver or similar.

[james]

Im trying to download all of the Active Directort Groups and their subsets

I have VBA code that works fine in exce, but I cnat get it to work in the load..

any ideas?

Sub GetADNames

Dim objGroup, objExcel, iRow, strUser, iColumn

Dim X As String

"A1"). Select

Do While ActiveCell.SpecialCells(xlCellTypeLastCell).Column + 1 > ActiveCell.Column

On Error Resume Next

Set objGroup = GetObject("LDAP://CN=" & X & ",ou=Qlikview Groups, ou=groups,ou=Users & Groups,dc=Test,dc=com")

For Each strUser In objGroup.Member

Set objUser = GetObject("LDAP://" & strUser)

Next

End With

Set objExcel = Nothing

Set objGroup = Nothing

Select

loop

End Sub

[Anonymous]

Hi,

Accidentally suggested your post as a solution. Buttons are too close for me 🙂

Anyway, what happens when you try to run the sub? It looks a little wierd to me also since you try to traverse an Excel file but there is no mention of creating any excel com object or loading any document.

[james]

I cant figure out how to call up the excel object?