Run VBA script from R

by

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()

More Related Contents:

  1. How can I generate a user password in R [closed]
  2. melt / reshape in excel using VBA?
  3. r: convert a string to date [duplicate]
  4. How to replace a value by another within a variable in R?
  5. Quickly reading very large tables as dataframes
  6. Calculating moving average
  7. standard evaluation in dplyr: summarise a variable given as a character string
  8. ggplot, facet, piechart: placing text in the middle of pie chart slices
  9. Exception handling in R [closed]
  10. Melt using patterns when variable names contain string information – avoid coercion to numeric
  11. Subset of rows containing NA (missing) values in a chosen column of a data frame
  12. Is there a more elegant way to convert two-digit years to four-digit years with lubridate?
  13. How to convert data.frame column from Factor to numeric [duplicate]
  14. Convert seconds to days: hours:minutes:seconds
  15. R gotcha: logical-and operator for combining conditions is & not &&
  16. Extract prediction band from lme fit
  17. Range standardization (0 to 1) in R [duplicate]
  18. Create a ranking variable with dplyr?
  19. ggplot2 : Plot mean with geom_bar
  20. Is there anything wrong with using T & F instead of TRUE & FALSE?
  21. Add error bars to show standard deviation on a plot in R
  22. How to add different lines for facets
  23. How can I add annotations below the x axis in ggplot2?
  24. Update/Replace Values in Dataframe with Tidyverse Join
  25. How to properly document S4 methods using roxygen2
  26. Run a custom function on a data frame in R, by group
  27. The perils of aligning plots in ggplot
  28. How to create a new variable in a data.frame based on a condition?
  29. Understanding element wise clearing of R’s workspace
  30. What does the %% operator mean in R? [closed]

Leave a Comment