4 Replies Latest reply: Dec 4, 2009 4:27 PM by James Phillips RSS

    VBA script during load?

    James Phillips

      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?

        • VBA script during load?
          Johannes Sunden

          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.

            • VBA script during load?
              James Phillips

              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