Results 1 to 9 of 9

Thread: VBA vs JAVA

  1. #1
    aielman is offline Member
    Join Date
    May 2008
    Posts
    4
    Rep Power
    0

    Default VBA vs JAVA

    Hello Folks,

    I am developing a GUI for an application using forms, once the form is filled the application has to generate an excel file and store the data as well as the result of some logic on this data in an excel file.

    I am new to Excel, i do not have much background in VBA but i am quite good in java, now i am confused whether should i implement this in java or VBA.

    I need some suggestions, which i should choose and why.

    Thanks for reading this topic, hope u'll help me out of this dilemma.

  2. #2
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

    Default

    Choice is yours pal. What you know well, can do anything you want. Doesn't matter on Java or else.

    But, the main advantage you have is, platform independent. If you build the application using Java, you can use it anywhere you want.

  3. #3
    aielman is offline Member
    Join Date
    May 2008
    Posts
    4
    Rep Power
    0

    Default

    Eranga thanks for the reply, i am running this application only on windows, so there is no issue of platform independence.
    If i write this program in java, writing and retreiving data would be something similar to accessing a DB, will it be any different when i write it in VBA. I have not worked on VBA so far so i am kinda afraid to walk in uncharted waters

  4. #4
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

    Default

    For me there is no much different at all. But if you MS Access, it's better to move with VBA. Because it can be easy in later developments.

    Best combination with Java is, SQL....

  5. #5
    aielman is offline Member
    Join Date
    May 2008
    Posts
    4
    Rep Power
    0

    Default

    I have not coded logic in VBA so far and i am not sure to wat extent does java offer support for MS Excel, apart from reading and writing a excel sheet.

  6. #6
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

    Default

    So I think the best thing is do a simple example. Go through a working example. On the web you can find a lot. Try and see, I'll give my support.

  7. #7
    aielman is offline Member
    Join Date
    May 2008
    Posts
    4
    Rep Power
    0

    Default

    Thank you eranga

  8. #8
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,372
    Blog Entries
    1
    Rep Power
    19

  9. #9
    danielstoner's Avatar
    danielstoner is offline Senior Member
    Join Date
    Apr 2008
    Location
    Canada
    Posts
    191
    Rep Power
    6

    Default

    If you want to use automation then it is easier to learn a bit of VBA and control an Excel instance to create your file. If you just want to create a CVS type file and then to import it in Excel you are ok with Java.
    Daniel @ [www.littletutorials.com]
    Language is froth on the surface of thought

Posting Permissions

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