Hello,
I do have a question as follows: I have an excel workbook which has multiple sheets and it generates some graphs with dynamic titles and footnotes using VBA language based on data in all these multiple sheets. Quarterly, only thing i need to do is to update data ( copy from SPSS and paste in excel) in each sheet and all graphs are updated accordingly. Recently, using R(openxlsx2 package), I am able to load the entire workbook in R environment , update it(only those specific cells that need to be updated) and export back without damaging its existing format and all VBA coding behind.
Now I am wondering can this be achieved in SAS if am asked to shift from R to SAS programming?
Thank you.
... View more