Populating a VBA combobox in Business Objects

[burkek]

What is the VBA syntax to connect to a universe and do a select on a table to populate a combobox?
The value to populate the combobox is an object in the universe.

 

[nimmy99]

Take a look at this one. Modify the following code. Hope it will help.
Sub manipulating()

Dim Doc As Document
Dim Rep As Report
Dim i As Integer
Dim Send As String

Set Doc = ActiveDocument
Doc.Refresh

For i = 1 To Doc.Reports.Count
Set Rep = Doc.Reports.Item(i)
MsgBox Doc.DataProviders.Item(1).Columns.Item(1).Name & " & " & Doc.DataProviders.Item(1).Columns.Item(2).Name

Next i



End Sub