philfer
01-20-2008, 11:44 AM
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)
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)