Need help populating a listbox with excel data

All,

 

I have a userform with a listbox.  At initialization, I want the listbox to be populated with values from an excel spreadsheet.  The range of the cells to be imported can be hard-coded into the program.  I just can't figure out how to get Microstation vba to "talk" to excel.  Any help is appreciated.

  • Referencing a COM Server

    mbarre@rtg-texas.com:

    I can't figure out how to get MicroStation VBA to "talk" to Excel …

    MicroStation VBA and Excel VBA are, in Microsoft terminology, COM servers. That means that you can connect from one application to another and use its COM server, usually provided by VBA. MicroStation VBA can reference Excel VBA; Excel VBA can reference MicroStation VBA.

    You add a reference to a COM server from the VBA Interactive Development Environment (IDE). Use the Tools|References menu to pop the References dialog (this has nothing to do with MicroStation reference attachments — we're talking Microsoft here).

    VBA References Dialog

    This article discusses Excel VBA and illustrates the referencing.

    Regards, Jon Summers
    LA Solutions

     
    Regards, Jon Summers
    LA Solutions