Building a System of Microsoft Windows Scripts to Control Excel Macros - Exchanging Data Between SAS and Microsoft Excel - page 225

Figure 13.3.9: Finished Graph of SASHELP.CLASS Data.
Figure 13.3.10a: Finished Visual Basic Code Module.
Also notice that the name of the workbook and/or the worksheet 'Table 1 - Data Set WORK.CLASS' may
appear embedded in the Excel macro code as part of the range of cells used as the data source for the chart
shown in Figure 13.3.10a. As shown above, the workbook name is not present, but the worksheet name is
shown. This will also cause the macro to force the debug mode to open and cause the macro to fail to finish
building the graph if the page name ever changes. When the workbook name (and the “!”) are removed, the