Skip to content

Installation & Execution

Brian Skinn edited this page Aug 9, 2021 · 9 revisions

Installation

Install as with any other Excel add-in (images shown are from Win7 and Excel 2013; click any image for a larger version):

  1. Download CSVExporter.xlam (see Releases)

  2. Save to %USERPROFILE%\AppData\Roaming\Microsoft\AddIns

  3. Open Excel

  4. Click File > Options
    'File > Options' screenshot

  5. Select the Add-Ins pane
    'Add-Ins pane' screenshot

  6. At the bottom of the dialog, in Manage: select Excel Add-ins and click Go...
    'Add-Ins pane' screenshot

  7. Check the box next to CSV Exporter and click OK
    'Add-Ins pane' screenshot

(Optional) Launch Button in Ribbon

If you would prefer to be able to launch CSV Exporter by clicking a button in the Ribbon, or if the Ctrl+Shift+C keystroke combination is misbehaving, follow these steps as well:

  1. First, open the Customize Ribbon pane of the Excel Options dialog.

    a. I usually reach it by dropping down the options menu for the Quick Access Toolbar and selecting More Commands... ...
    'Customize Quick Access Toolbar' screenshot

    b. ... and then selecting Customize Ribbon on the left.
    'Select Customize Ribbon' screenshot

  2. Ensure Main Tabs is selected in Customize the Ribbon and Home is selected within Main Tabs, then click New Group.
    'Creating new group' screenshot

  3. Select the newly created group and click Rename....
    'Renaming new group' screenshot

  4. Choose a suitable symbol and revise the Display name to read "CSV Exporter".
    'Configuring new group' screenshot

  5. Select Macros from the Choose commands from drop-down, then find and select the showCSVExporterForm macro (for v1.2.1 or later), or the showForm macro (for v1.2.0 or earlier).
     
    Then, after making sure the "CSV Exporter" group remains selected, click Add >>.
    'Adding CSV app macro command' screenshot

  6. Select the newly-added showCSVExporterForm (or showForm) macro entry and click Rename....
    'Renaming CSV app macro command' screenshot

  7. Choose a suitable symbol and revise the Display name to read "Launch".
    'Configuring new macro command' screenshot

  8. Click OK to close the options dialog.

A launch button for CSV Exporter should now appear at the far right of the Home Ribbon:

'New launch button' screenshot

Execution

Load CSV Exporter within Excel by pressing Ctrl+Shift+C, or by clicking the custom Ribbon button created via the above steps.

Clone this wiki locally