从VBA代码启动jar文件 [英] Launch jar file from VBA code
问题描述
我有一个.jar文件,它从SQLite DB加载到某个字段以显示在框架中.
I have a .jar file that it load from SQLite DB some field to show in the frame.
如果我通过双击手动运行.jar很好,但是如果我使用以下VBA代码运行文件:
If I run the .jar manually with double click all is fine, but if I run the file with this VBA code:
Private Sub Comando8_Click()
Set WshShell = CreateObject("WScript.Shell")
strDocuments = WshShell.SpecialFolders("MyDocuments")
FileName = "\HotelFiller\HotelFiller.jar /foo"
strDocuments = strDocuments + FileName
WshShell.Run strDocuments
End Sub
程序运行,但不从SQLite DB加载该字段.我在哪里错了?
The program run but don't load the field from SQLite DB. Where am I wrong?
推荐答案
jar不是exe.当您双击一个jar文件时,它可以工作.就像您单击txt文件一样,记事本将执行并读取txt文件,显示内容.
jar is not exe. when you double click a jar file, it works. Just like you click on a txt file, notepad will execute and read the txt file, show the content.
jar文件也是如此.双击jar文件时,系统(我想是Windows)将启动java.exe,java.exe将启动jar文件并从jar中执行代码.
So does jar file. When you double click the jar file, system(Windows I suppose) will launch java.exe, java.exe will launch the jar file and execute the code from jar.
我不是VB专家.但是您可以尝试将FileName = "\HotelFiller\HotelFiller.jar /foo"
替换为FileName = "java -jar \HotelFiller\HotelFiller.jar /foo"
I am not an expert of VB. But you can try to replace FileName = "\HotelFiller\HotelFiller.jar /foo"
with FileName = "java -jar \HotelFiller\HotelFiller.jar /foo"
java -jar xxx.jar
是可用于在cmd中运行jar的东西.
java -jar xxx.jar
is what you can use to run a jar in cmd.
看看您的VB代码.我想在jar中,使用System.out.println输出结果?您需要找到一种方法来启动执行java -jar \HotelFiller\HotelFiller.jar /foo"
的进程.并从标准输出中获取输出.您使用它的方式似乎是一个文字字符串分配.
Take a look at your VB code. I suppose in the jar, the result is outputted using System.out.println? You need to find a way to launch a process to execute java -jar \HotelFiller\HotelFiller.jar /foo"
. And get the output from standard output. The way your are using it seems like a literal string assignment.
这篇关于从VBA代码启动jar文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!