I. PROGRAMMING DESIGN

With the advent of Visual Basic for Applications (VBA) and Object Linking and Embedding (OLE), macros can be written to bring wonders to programming. This paper gives simple sample code to exemplify the integration of SAS ® software and Microsoft Office software to automate the production of customized graphs. During the presentation, a more fully developed application complete with dialog boxes for generating a variety of graphs via option and command buttons will be demonstrated