VBA and Rstudio

[Roadhouse]

Hi is it possible with a vba macro to open Rstudio at a certain time say 21:00 and press run in Rstudio then close Rstudio without saving when my program finishes running?

[Roadhouse]

Any suggestions ?

[MrShorty]

I think you are looking for the Shell function: https://msdn.microsoft.com/EN-US/lib.../gg278437.aspx
http://www.taltech.com/support/entry...ation_from_vba
From there, you would need to know the RStudio object model well enough to perform the desired actions.