Import-export SAP2000 to excel or to acess with the OAPI

[borja1980]

Hello. I need to export and import data from a SAP2000 model to Excel or to a sap.mdb file. I consulted the OAPI manual but did not find anything. Does anybody know how I could the import export commands with OAPI?
thanks

 

[Sarkheil]

hi!

in Edit Menu, Choose Interactive database editing, then choose tables and press OK. In new opened window and with using the button "To Excel" and "From Excel" you can interactive data between excel and sap.

 

[borja1980]

thanks for your reply. I already know hot to importa and export with the user interface. The thing is, I would like to import and export with code written in Visual Basic for Applications (VBA). SAP2000 supports this lenguage, with OAPI. The OAPI manual explains several commands, but the commands referring to import and export are missing. thanks again, anyway!!

 

[mahdir1000]

Hi.if you find how import or export information by oapi ,tell we how you do this work.tancks