0

I am trying to start a R-Script by using a button in Access. I tried this VBA code (I never learned VBA, just tried to help myself) but nothing happens. Maybe someone can help me.

Private Sub RunRscript()

Dim path As String

path = "D:\programme\r\R-4.0.1\bin\x64\R.exe G:\data\data_v25\backgroundv\baclgroundv_Access.R"

Call shell(path, 1)

End Sub
user438383
  • 4,338
  • 6
  • 23
  • 35
mojojojo
  • 1
  • Have a look at [this StackOverflow question about executing shell commands in VBA](https://stackoverflow.com/questions/2290365/how-can-i-execute-a-shell-command-using-vba). – Luca Polito Aug 20 '21 at 12:44

0 Answers0