Microsoft announced in early 2012 that it would extend support for aging Visual Basic ... button or other control option to create a new workbook and export data to it for use in Excel.

The Visual Basic "Button" class lets you create a control on your VB projects that perform an action such as auto-save. VB also includes file classes that help you create functions to save files.

Investopedia / Theresa Chiechi Visual Basic for Applications ... and data-processing functions. You can write a macro with a single click that will allow Excel to create an entire balance sheet ...