Exchanging Data between SAS and Microsoft Excel

Chapter 11: Using DDE to Read and Write to Excel Workbooks

11.1 Introduction

11.2 Purpose

11.3 Basic Concept of the DDE Client-Server Environment

11.3.1 How the DDE Client-Server Relationship Works

11.3.2 General DDE Syntax and Options

11.4 List of User-Written SAS Macros That Can Enhance DDE Processing

11.4.1 SAS Macro to Start Excel

11.4.2 SAS Macro to SAS to Issue Commands to Excel

11.4.3 SAS Macro to Define a Range of Excel Cells for Processing

11.4.4 SAS Macro to Save the Contents of an Excel Workbook

11.4.5 SAS Macro to Close Excel Workbook

11.4.6 SAS Macro to Write All or Selected Variables to an Excel Output Workbook

11.5 List of Examples

11.6 Examples

Example 11.6.1 The Hello World Project

Example 11.6.2 The Hello World Project When ...