A macro is a text file that contains a series of Minitab session commands. You can use macros to automate a repetitive task (for example, generating a monthly report) or to extend Minitab's functionality (for example, computing a special test statistic).
The easiest way to create an Exec file is to save command language from the History pane.
The following steps will save all the commands in the History pane. If you have just a few lines that you want to save from the History pane, highlight them, and copy and paste into a text editor, such as Notepad, then save the file using a .mtb file extension.
To run an Exec, you could also drag and drop the Exec file on a Minitab shortcut.
Yes. The COLUMNS subcommand is required in local macros. COLUMNS specifies which columns of the Minitab worksheet should hold the data. In global macros or exec files, executing the ODBC command without the COLUMNS subcommand places new data at the end of the global worksheet.