VBA reference libraries

%3CLINGO-SUB%20id%3D%22lingo-sub-2722043%22%20slang%3D%22en-US%22%3EVBA%20reference%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2722043%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EIf%20I%20want%20to%20interact%20with%20another%20application%20using%20Excel's%20VBA%2C%20how%20can%20I%20find%20out%20what%20is%20the%20correct%20reference%20library%20to%20be%20selected%3F%20Finding%20PowerPoint%20reference%20library%20is%20very%20straightforward%20and%20easy%2C%20but%20SAP%2C%20for%20instance%2C%20seems%20to%20have%20many%20and%20I%20don't%20know%20which%20is%20the%20correct%20one%20to%20interact%20with%20SAP%20Hana%20(to%20combine%20VBS%20script%20with%20VBA).%20Can%20this%20be%20normally%20found%20in%20the%20Help%20tool%20of%20each%20application%3F%20Is%20there%20any%20convention%20to%20find%20the%20reference%20library%20in%20commonly%20used%20applications%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2722043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENotifications%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2729552%22%20slang%3D%22en-US%22%3ERe%3A%20VBA%20reference%20libraries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2729552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1147271%22%20target%3D%22_blank%22%3E%40Jose_Carlos%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%26nbsp%3BCommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

1 Reply

@Jose_Carlos 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.