Hello, Could someone help with code for creating a new calculated measure in VBA? Thanks!
D debjake2002 New Member Jul 28, 2016 #1 Hello, Could someone help with code for creating a new calculated measure in VBA? Thanks!
Chihiro Excel Ninja Jul 28, 2016 #2 Try using Model.ModelMeasures.Add method. See link for syntax. https://msdn.microsoft.com/en-us/library/office/mt574976.aspx However, this is only available in Excel 2013 & later. If using 2010, you are out of luck.
Try using Model.ModelMeasures.Add method. See link for syntax. https://msdn.microsoft.com/en-us/library/office/mt574976.aspx However, this is only available in Excel 2013 & later. If using 2010, you are out of luck.
D debjake2002 New Member Jul 28, 2016 #3 Chihiro said: Try using Model.ModelMeasures.Add method. See link for syntax. https://msdn.microsoft.com/en-us/library/office/mt574976.aspx However, this is only available in Excel 2013 & later. If using 2010, you are out of luck. Click to expand... Thanks, Chihiro!! I will give it a try.
Chihiro said: Try using Model.ModelMeasures.Add method. See link for syntax. https://msdn.microsoft.com/en-us/library/office/mt574976.aspx However, this is only available in Excel 2013 & later. If using 2010, you are out of luck. Click to expand... Thanks, Chihiro!! I will give it a try.