Run ruby script through vba

Question

Is there a way to start a Ruby script from through an Excel macro?

The macro creates two CSV files and I would like to automate the procss of running

ruby dostuff.rb file1.csv file2.csv

try something like: Shell("C:\Temp\gc.exe 1", vbNormalFocus) — Kiril
– Kiril, Commented Dec 16, 2015 at 15:23
Mmm... I think you can do all from VisualBasic without call a ruby script — Juanjo Salvador
– Juanjo Salvador, Commented Dec 16, 2015 at 15:30
I tried Shell(" ruby C:\Folder1\dostuff.rb file1.csv file2.csv" ) — RealCheeseLord
– RealCheeseLord, Commented Dec 16, 2015 at 15:36
@Conny are file1 and file2 in the same directory as your excel sheet? Maybe you should fully qualified name — Kiril
– Kiril, Commented Dec 16, 2015 at 15:38
@Kiril damn you are right, I forgot to add C:\Folder1\ to the files.... Thank you — RealCheeseLord
– RealCheeseLord, Commented Dec 16, 2015 at 15:40

RealCheeseLord · Accepted Answer · 2015-12-16 15:45:14Z

1

+50

The comment section made it clear: fully qualify your parameters, if they are files, and the files are not in the same directory as your Excel sheet.

Shell("ruby C:\Folder\dostuff.rb C:\Folder\file1.csv C:\Folder\file2.csv", vbNormalFocus)

edited Dec 16, 2015 at 15:45

RealCheeseLord

7951 gold badge12 silver badges24 bronze badges

answered Dec 16, 2015 at 15:43

Kiril

6,27913 gold badges61 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

S Meaden · Accepted Answer · 2017-08-01 10:58:12Z

1

Sometimes you need to use the environment variable comspec to successfully launch external program from VBA. See these blog search result for examples.

edited Aug 1, 2017 at 10:58

answered Aug 1, 2017 at 10:49

S Meaden

8,3203 gold badges39 silver badges74 bronze badges

Comments

Florent B. · Accepted Answer · 2017-08-01 23:12:28Z

There are multiple ways to run a ruby script with VBA.

With Shell, asynchronous with console:

Public Sub RunRuby(file As String, ParamArray args())
  Shell "ruby.exe """ & file & """ " & Join(args, " ")
End Sub

With Shell, synchronous without console:

Public Sub RunRuby(file As String, ParamArray args())
  Shell "rubyw.exe """ & file & """ " & Join(args, " ")
End Function

With WScript.Shell, synchronous without console and with exit code:

Public Function RunRuby(file As String, ParamArray args()) As Long
  Dim obj As Object
  Set obj = CreateObject("WScript.Shell")
  RunRuby = obj.Run("rubyw.exe """ & file & """ " & Join(args, " "), 0, True)
End Function

And to set the working directory in case there's a relative path:

ChDir "C:\Folder1"

, or with the folder of the current workbook:

ChDir ThisWorkbook.Path

Collectives™ on Stack Overflow

Run ruby script through vba

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related