Solved: object models for non-MS apps

[philfer]

Does anyone know if there is anywhere where I can find a worked practical example that runs through the steps of :-

1) Identifying the object model for a non-MS app
2) Discovering the type libraries and tables for this app
3) Setting a reference for this app
4) Writing VBA code to manipulate it

There seems to be loads of stuff around about how to connect to MS-apps but none for non-MS apps which I think is the real challenge but very useful as more organisations are using in-house built systems (especially I have found for accountancy)

[Bob Phillips]

I responded to post in Excel forum.