Database Reference
In-Depth Information
Table 13.3.2: Comparison of Tools Described in Chapter 12 and Chapter 13.
Function
Program
Chapter 12 Personal Workbook Tool
Chapter 13 Macro Library Tool
Individual Macro Storage
Excel Macros Stored in Departmental
Directory
1.
Build *.xml file.
2.
Set control value in cell A1 label of
first sheet.
3.
Use “X” command to send output file
name to Excel for execution by
Excel.
1.
Build *.xml file or xls file.
2.
Define path and file for *.xml file.
3.
Define path and file for *.xls file.
4.
Define path and name of *.vbs file.
5.
Define path and name of *.BAS file.
6.
Define name of Excel macro to execute.
7.
Send path, file, and macro names to
windows *.vbs.
SAS
1.
Open Excel.
2.
Load report specific macro.
3.
Load project common macros.
4.
Execute report specific macro.
5.
Delete all Excel macros loaded.
6.
Save updated file.
7.
Close Excel.
8.
End VBS script.
VBS
NO VBS routines are used
Excel
workbook
built by
SAS
First sheet, Cell A1, contains control
information
Any xml, xls, or other file that can be read
into Excel at Excel start-up time.
1.
The code module ThisWorkbook
stored in the user's “Personal Macro
Workbook” contains VBA code to
select the requested macro
processing. Each computer may have
different code here.
2.
An Excel “module” is used to store
recorded Excel macros.
Excel
Personal
Workbook
NOT USED
1.
Stores the VBS code.
2.
Write-protect the file if necessary.
3.
Store on departmental drive.
4.
Is accessible to many users.
VBS code
library
NONE
1.
Stores the VBA code.
2.
Write-protect the file if necessary.
3.
Store on departmental drive.
4.
Is accessible to many users.
BAS code
library
All BAS code is stored in the “Personal
Macro Workbook” on the user' computer.
Each user's macros are independent of
any other user's.
As shown in Table 13.3.2, the tools that are defined in chapters 12 and 13 store the Excel macros in
different places. Chapter 12 uses the Personal Workbook that is stored in a system-defined location on the
Search WWH ::
Custom Search