title: saveWorkbook function saves without macros
body: <p>I am trying to use a VBA macro to call an R script to clean data based on variables in the excel workbook. I am having troubles pasting the cleaned data back into the excel workbook.  I can use saveWorkbook to save it as an .xlsm file, however once I open the file, all my pre-set macros are gone, just disappeared. Is there a way to save the xlsm from R that keeps the macros intact? </p>
  
  <p>As another note, is there a way to write this and have it update so that the file does not need to be closed and reopened? Is there a way to have it run in the same manner as a macro? </p>
  
  <pre><code>wb &lt;- loadWorkbook(file.xlsm) 
  writeData(wb, sheet = "DataSet", data, startCol = 1, startRow = 2, colNames = FALSE) 
  saveWorkbook(wb, file = file.xlsm, overwrite = TRUE)  
  </code></pre>
  
  <p>It runs fine, but all the macros are gone. The file size goes from 806KB to 27KB</p>