Results 1 to 4 of 4
  1. #1
    megatronixs is offline Member
    Join Date
    Jul 2015
    Posts
    2
    Rep Power
    0

    Default java applet and excel vba

    Hi all,

    This is my first post on Java Forums :-) so, it is possible that my question/s could sound silly at the beginning.

    I have an oracle java applet at work where we need to imput in serveral fields some information that we have in an excel sheet. This could be over 100 rows. I was thinking that I it could be automated so the excel macro will loop row by row, copy paste into the first field, copy the next cell from the row, paste it in the second field and then press the F8 button so the data is processed and then goes to the next row.

    How could I let's say, talk to java applet alt+n to go the the next record?

    Is there any code that could be used to "talk" to the java oracle applet via vba ?

    Sorry for my silly question.

    Greetings.

  2. #2
    benji2505 is offline Senior Member
    Join Date
    Sep 2014
    Location
    MA, USA
    Posts
    399
    Rep Power
    6

    Default Re: java applet and excel vba

    Do you have access to the source code of the applet?

  3. #3
    megatronixs is offline Member
    Join Date
    Jul 2015
    Posts
    2
    Rep Power
    0

    Default Re: java applet and excel vba

    Hi,
    No, I don't have access to it, we can only open the application and work with it.
    I tried with send keys, but it does not work at all :-(

    Greetings.

  4. #4
    benji2505 is offline Senior Member
    Join Date
    Sep 2014
    Location
    MA, USA
    Posts
    399
    Rep Power
    6

    Default Re: java applet and excel vba

    think about it from the perspective of the applet: they have some sort of input (stream?) that is checked before being processed and the applet expects certain criteria for the allocation to certain variables. Unless there is some sort of by-pass that was programmed but not documented for the user you might be out of luck.

Similar Threads

  1. Replies: 0
    Last Post: 07-17-2014, 04:18 AM
  2. Replies: 0
    Last Post: 02-21-2014, 11:04 AM
  3. Replies: 0
    Last Post: 04-26-2013, 02:48 PM
  4. Replies: 1
    Last Post: 08-27-2012, 04:23 PM
  5. Replies: 30
    Last Post: 08-26-2011, 09:05 PM

Posting Permissions

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