从Excel中的按钮运行Sikuli [英] Run Sikuli from button in Excel

问题描述

我是VBA的新手.在Excel工作表中，我有数据.在每一行的结尾，我都有一个onclick按钮.

I am new to VBA. In Excel sheet I have data. At the end of the every row I have an onclick button.

我的要求是，当我单击按钮时，它必须在命令提示符下运行Sikuli.

My requirement is when I click on a button it has to run Sikuli from command prompt.

哪个命令用于在VBA中打开并运行命令提示符?

Which command is used to open and run the command prompt in VBA?

推荐答案

我不知道sikuli，但是如果您希望通过VBA代码运行命令行作为单击按钮的一部分，请查看Shell命令./p>

I don't know sikuli, but if you want to run a command line from VBA code as part of a button click, look at the Shell command.

Private Sub CommandButton1_Click()
  dblRetVal = Shell("java -jar %SIKULI_HOME%\script.jar path\yourScript.sikuli", vbHide)
  'VBHIDE HIDES SHELL WINDOW (BLACK DOS WINDOW)
End Sub

这篇关于从Excel中的按钮运行Sikuli的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！