You can customize and automate common tasks using Visual Basic for Applications (VBA) functions in Smart View using Excel's Visual Basic Editor.
Assumed Knowledge
VBA Parameters
VBA Return Values
VBA Functions
VBA Functions and Dynamic Link Views
Visual Basic Menu Functions
Using Spreadsheet Toolkit VBA Applications in Smart View