Exchanging Data between SAS and Microsoft Excel

Chapter 13: Building a System of Microsoft Windows Scripts to Control Excel Macros

13.1 Introduction

13.2 Purpose

13.3 Guidelines for Building and Using a VBS/VBA Macro Library

13.3.1 Create Naming Conventions for Storing and Executing VBS/VBA Macros

13.3.2 Set Up Workstation Options

13.3.3 Where to Store VBS/VBA Scripts and Macros

13.3.4 SAS Code to Execute a Visual Basic Script

13.3.5 Build a Parameter-Driven VBS Script to Control the Execution of Excel

13.3.6 Build a Control Macro for Each Excel Report

13.4 Conclusion

13.1 Introduction

Chapters 12, 13, and 14 each define separate, but increasingly powerful tools that combine SAS and Excel features and that integrate your ability to transfer data between SAS and Excel. At the beginning of each ...