RE: Altair slc adding a sheet to a xlsm workbook

Roger DeAngelis_21630

RE: Altair slc adding a sheet to a xlsm workbook

The posted response stated that Monarch does not support exports to a macro-enabled workbook;

Too long to post in listserv, see github

gihub
https://github.com/rogerjdeangelis/utl-altair-slc-adding-a-sheet-to-a-xlsm-workbook

community.altair.com
https://community.altair.com/discussion/6403

SOLUTION

1 CREATE XLSM WORKBOOK WITH MACRO. SUM A2-A21


  Sub sum_weight()

      Range("A21").Select

      ActiveCell.FormulaR1C1 = "=SUM(R[-19]C:R[-1]C)"

      Range("A22").Select

  End Sub



2 ADD A SECOND WORKSHEET CLASS TO XLSM WORKBOOK