Wednesday, July 18, 2012

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