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 Function Types
Using Spreadsheet Toolkit VBA Applications in Smart View