I have been involved in five such projects. However, the text has been rewritten to (1) describe my experience of this type of project, (2) answer the true question and (3) better explain the solution. The code within this version of the answer is essentially unchanged from the previous version. Can you please tell me how can I run the macros with enabling all macros option in Excel. I have seen people creating and running macros without doing this. Workbooks.Open Filename:=xlsPath & xlsFileĪctiveChart.SetSourceData Source:=Range("'TEST'!$A$1:$B" & lastRow)ĪctiveSheet.ChartObjects("Chart 2").ActivateĪctiveChart.Axes(xlCategory).ReversePlotOrder = TrueĬan anyone help me in solving this puzzle please.Īlso for running any macro automatically from SAS, I always have to change the Excel options for "enable all macros" which I suppose is not good. Whenever I run it, it gives "smr run time error" and I am not able to figure out what is wrong with my code. I created a macro in Excel for creating bar graphs automatically.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |