Results 1 to 9 of 9

Thread: Java versus VBA

  1. #1
    waspandbee is offline Member
    Join Date
    Jun 2010
    Posts
    3
    Rep Power
    0

    Default Java versus VBA

    Hi,

    I'm currently doing an assignment which involves pulling data threads from a source and displaying it such that a user can manipulate the data and use the data for trading decisions.

    So I was wondering what are the pros and cons of using Java or using VBA on this particular assignment.

    Either way, my group is still indecisive as half of us want Java and the other half want VBA.

  2. #2
    Fubarable's Avatar
    Fubarable is offline Moderator
    Join Date
    Jun 2008
    Posts
    19,316
    Blog Entries
    1
    Rep Power
    26

    Default

    How do the functionality of Java and VBA intersect? Java and VBA are used for two completely different set of circumstances, and for the life of me, I can't think of a project where you'd be deciding between one or the other. Sure Java vs. Visual Basic, but Java vs. Visual Basic for Applications? Please educate me here.

  3. #3
    JosAH's Avatar
    JosAH is offline Moderator
    Join Date
    Sep 2008
    Location
    Voorschoten, the Netherlands
    Posts
    13,658
    Blog Entries
    7
    Rep Power
    21

    Default

    Quote Originally Posted by waspandbee View Post
    So I was wondering what are the pros and cons of using Java or using VBA on this particular assignment.

    Either way, my group is still indecisive as half of us want Java and the other half want VBA.
    Edsger W. Dijkstra about Basic: "The teaching of Basic should be rated as a criminal offence: it mutilates the mind beyond recovery".

    kind regards,

    Jos

  4. #4
    dinosoep is offline Senior Member
    Join Date
    Nov 2009
    Posts
    150
    Rep Power
    5

    Default

    with vba, your going to get a quicker result.
    with java, your going to get a slower (more work) but in the end better result which is cross-platform.
    your choice.

  5. #5
    gcalvin is offline Senior Member
    Join Date
    Mar 2010
    Posts
    953
    Rep Power
    5

    Default

    VBA is all about automating Office applications. If your app will be centered around Excel, for example, it may make sense to do it in VBA. If the core of your app is not Excel (or some other Office application) but you want to use Office apps for reporting, etc., there are plenty of Java tools that will allow you to do that. It may even make sense to do portions of it in VBA and other portions in Java or some other language -- for instance, your VBA code could call a web service written in Java to get some dynamically-updated information.

    -Gary-

  6. #6
    waspandbee is offline Member
    Join Date
    Jun 2010
    Posts
    3
    Rep Power
    0

    Default

    Yes, my app is centred around excel. One of our plan is to create a trading platform for students to learn and 'experience' FOREX trading. So we are going to have to make sure our trading data is dynamic (Our source is probably reuters traders asia).

    To fubarable: Can you elaborate on how Java and VBA are used for two completely different set of circumstances? Thanks.

  7. #7
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,097
    Rep Power
    20

    Default

    Which one do you know best?
    Is there a significant difference in your level of knowledge between Java and VBA in Excel?

  8. #8
    waspandbee is offline Member
    Join Date
    Jun 2010
    Posts
    3
    Rep Power
    0

    Default

    I know more about VBA than Java. Erm, but what are the benefits of using VBA for a trading application. I know some people who have done so using VBA. What are the comparisons between Java and VBA for such an app?

  9. #9
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,097
    Rep Power
    20

    Default

    Quote Originally Posted by waspandbee View Post
    I know more about VBA than Java. Erm, but what are the benefits of using VBA for a trading application. I know some people who have done so using VBA. What are the comparisons between Java and VBA for such an app?
    Well, if it's just for:
    "One of our plan is to create a trading platform for students to learn and 'experience' FOREX trading"

    Then it really doesn't matter what it's done in surely?
    It's for demoing something else to the students.

    I'd use whatever lanuguage you felt most comfortable with, and you felt delivered the end results you're looking for. I presume the app is doable with either language, otherwise you wouldn't be asking...I don't know VBA beyond the odd brush with it in the past.

Similar Threads

  1. Replies: 1
    Last Post: 02-23-2009, 06:48 PM
  2. ArrayList versus Array
    By junpogi in forum New To Java
    Replies: 13
    Last Post: 11-08-2008, 02:04 AM

Tags for this Thread

Posting Permissions

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