none
RFI | How to invoke java methods from VBA or VB RRS feed

  • Question

  • Hi All,

     Currently we have an excel add-in(written in VBA) which needs to interact with the server(Asset Control server) and populates information to the excel sheet. But there is no way to connect the server from VBA. However Asset control provides some Java APIs which can be used for this purpose.

     So, we are trying to find some way to call java APIs from our excel add-in code base(i.e. VBA or VB). Is there anyone who came across such requirement and solved that issue? While searching in net we found ABBA as third party tool which provides this kind of requirement. But we are not sure if this is best one available in market.

     Summary of the requirement:

    -       Write a excel function in VBA

    -       While fetching for the excel function it should invoke the AC Java APIs

    -       AC Java APIs interact with server and return back the required information

    -       Populate the information in the excel sheet

     Question:

    -       Is there any third party tool available in market which helps to call Java from VBA or VB code base?

    -       Which tool is open source and best in this business?

     Quick response will be highly appreciated.

     For any more clarification please do let me know.

     Thanks & Regards,

     Pankaj

    • Moved by lucy-liu Friday, November 4, 2011 7:57 AM it is about java and vba (From:Visual Studio Extensibility)
    Wednesday, November 2, 2011 3:53 AM

All replies

  • Hi pkalita,

    See whether following link is helpful:

    Using JAVA inside VBA (EXCEL 2003 VBA)

    http://windowssecrets.com/forums/showthread.php/96936-Using-JAVA-inside-VBA-(EXCEL-2003-VBA)

    In addition, this issue is off-topic here, I recommend you to write a new post to a more suitable forum for a better support.

    This response contains links reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you.Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.

    There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Thank you for your understanding!

    Best regards,

    Lucy


    Lucy Liu [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.



    • Edited by lucy-liu Thursday, November 3, 2011 5:29 AM
    Thursday, November 3, 2011 5:22 AM