If I want to interact with another application using Excel's VBA, how can I find out what is the correct reference library to be selected? Finding PowerPoint reference library is very straightforward and easy, but SAP, for instance, seems to have many and I don't know which is the correct one to interact with SAP Hana (to combine VBS script with VBA). Can this be normally found in the Help tool of each application? Is there any convention to find the reference library in commonly used applications?
