vba to open java window

Discussion in 'Programming' started by stu, Aug 31, 2012.

  1. stu

    stu

    I'm looking for a simple method in vba to open a java window (file) on the lines of


    • Sub openstuff()

      Shell("java.exe -jar" & "C:\myaddressFile\mytargetInfo.jar")

      End Sub

    That runs ok but nothing happens!
    Anyone help?
     
  2. LeeD

    LeeD

    You have space missing between "-jar" and the file name
     
  3. stu

    stu

    Many thanks LeeD, I'm much obliged to you :)