0

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

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

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

Community
  • 1
  • 1
pravallika
  • 67
  • 2
  • 12
  • http://www.teachexcel.com/free-excel-macros/m-47,open-any-program-or-file-from-excel.html – Jüri Ruut Nov 02 '12 at 12:09
  • how to get vbscript variables in sikuli?please help me if any one knows the syntax to get vbscript variables in sikuli or in python. – pravallika Nov 05 '12 at 09:53
  • It's the best if you start your last question as a totally new question. For other people the thread is answered and out of sight already, I am the only one who got a new question as a comment. – Jüri Ruut Nov 05 '12 at 09:59

1 Answers1

0

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
Richard Morgan
  • 7,601
  • 9
  • 49
  • 86