Run VBA script from R
Here's a method which doesn't require a VBscript wrapper. You'll need to install the RDCOMClient
package
library(RDCOMClient)
# Open a specific workbook in Excel:
xlApp <- COMCreate("Excel.Application")
xlWbk <- xlApp$Workbooks()$Open("C:\\Temp\\macro_template.xlsm")
# this line of code might be necessary if you want to see your spreadsheet:
xlApp[['Visible']] <- TRUE
# Run the macro called "MyMacro":
xlApp$Run("MyMacro")
# Close the workbook and quit the app:
xlWbk$Close(FALSE)
xlApp$Quit()
# Release resources:
rm(xlWbk, xlApp)
gc()
Write a VBscript wrapper that calls your VBA. See Way to run Excel macros from command line or batch file?
Run your VBscript via R's
system
orshell
functions.