Consulting

Results 1 to 6 of 6

Thread: Updating fields on external input

  1. #1

    Updating fields on external input

    Is it possible for the fields in my application to automatically update when it receives some notification message?

    The message is a JMS message received by a Java application running in a background thread. When the Java app receives the message, it does some processing and sends some data to my Excel spreadsheet. The spreadsheet is then supposed to automatically update based on this data. Can I register some sort of listener in VBA to listen for this message?

    Thanks.

    [edit] Or alternatively, is it possible to continually poll some location/file at regular intervals to check for updates?

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    I would probably use a vb.net program like what I posted at http://www.wpuniverse.com/vb/showthr...threadid=31419

    If don't want to join the WordPerfect forum, you can PM your email to me and I will send the zip file example.

  3. #3
    VBAX Regular
    Joined
    Nov 2010
    Location
    Las Vegas Nv
    Posts
    74
    Location
    How does it send the data to your spreadsheet? if you're able to change the java program, there are a couple of easy ways to accomplish that goal

  4. #4
    Quote Originally Posted by Sean.DiSanti
    How does it send the data to your spreadsheet? if you're able to change the java program, there are a couple of easy ways to accomplish that goal
    That's the question I'm asking, how do I send data to the spreadsheet..?

  5. #5
    Quote Originally Posted by Kenneth Hobs
    I would probably use a vb.net program like what I posted at ...
    If don't want to join the WordPerfect forum, you can PM your email to me and I will send the zip file example.
    Thanks! Looks like something that would work for my application.

  6. #6
    VBAX Regular
    Joined
    Nov 2010
    Location
    Las Vegas Nv
    Posts
    74
    Location
    if you're able to modify the java program, you could just have it create a file and have excel read it in when the file exists, and delete the file after reading it in.

Posting Permissions

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