Building a System of Excel Macros Executable by SAS - Exchanging Data Between SAS and Microsoft Excel - page 193

Figure 12.3.2b: Excel Record Macro Window to Input Macro Name, Hot-Key, and Storage
Location.

Table 12.3.2: Default Locations of Excel Personal Macro Workbooks.

Software Usual Default Location - Your location may vary by either Excel version or

operating system version. Check with your IT Department to verify the
location.

Common paths on older operating systems.

Excel 2003 C:\Program Files\Microsoft Office\Office11\XLSTART

Excel 2007 C:\Program Files\Microsoft Office\Office12\XLSTART

The XLSTART directory is considered a trusted location. To locate it, check the following.
For Excel =

To locate the XLSTART directory path:

2007, 2010, and 2013 With Excel open, select “Excel Options”, and then select the “Trust Center”

button.

Select “Trust Center Settings”, and then select the “Trusted Locations” button.

Look for the path for the Excel XLSTART file. (See Figure 12.3.3a.)