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.
mbarre@rtg-texas.com: I can't figure out how to get MicroStation VBA to "talk" to Excel …
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).
This article discusses Excel VBA and illustrates the referencing.
Regards, Jon Summers LA Solutions