Visual Basic for Applications?!
Just finished a bunch of VBA (of all things) to do some dynamic chart coloring based on values in a table being loaded from a SharePoint list. The chart will be hosted in SharePoint. Unfortunately I can't use UDF to do a dynamic refreshing of the chart since Excel Services doesn't support running VBA in Excel workbooks. Pity.
No comments:
Post a Comment