Open your workbook in Excel. Press Alt + F11 to open Visual Basic Editor (VBE). Right-click on your workbook name in the "Project-VBAProject" pane (at the top left corner of the editor window) and ...

Your script can manipulate data, perform common Excel functions such as graph creation or automatically input data into specific cells. Only Visual Basic code can be used with the VBA editor.

A small VBA script that converts Excel tables to JSON format and exports the data to a file at the location of your choice ...

To give an Excel macro "Save As" functionality, you can use the Excel VBA GetSaveAsFilename function. This is part of the "Application" group of functions, since it is part of Excel's core ...

If you make heavy use of VBA in Microsoft’s Office 2004, you might find an upcoming VBA to AppleScript guide a useful addition to your toolkit.