+ Reply to Thread
Results 1 to 2 of 2

Compiling/Registering Java File to Be Called/Access by VBA

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    OP,KS
    MS-Off Ver
    Excel 2003
    Posts
    17

    Compiling/Registering Java File to Be Called/Access by VBA

    I have a .java file with a function in it.
    I have Netbeans.
    ...And I have Excel and VBA.

    What do I need to do to call a function from a java file in VBA? I have read things online such as using javareg to register the class file (which is obsolete). I am just confused on how to correctly compile or register this file.

    I think the VB code is for example
    Set vj = CreateObject("DoubleInt")
    MsgBox vj.IntTimesTwo(100)
    Where for example the .java file is called DoubleInt and the only function is IntTimesTwo.

    But am clueless on the connection between the two. Although this is pointless, knowing this will help me to add other java files that are much more complex.

  2. #2
    Registered User
    Join Date
    06-22-2009
    Location
    OP,KS
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Compiling/Registering Java File to Be Called/Access by VBA

    Well instead of having the two communicate, i just have Java produce an excel file (CSV), and excel wait for the file to be there, then let excel access it.

    Not my solution, but it does the job.
    Last edited by ngay528; 07-22-2009 at 09:38 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1