User's Guide

Part V. The SQL Anywhere Programming Interfaces

Chapter 37. The WSQL DDE Server

There are a number of Excel Macro Sheet DDE functions that can access the WSQL DDE Server DDE Server. The Query.to.clipboard macro shown in demonstrates the use of Macro Sheets to initiate and terminate a DDE conversation, connect and disconnect from a database, and clip data. (Excel supports Execute, although this example doesn't use it.)

This macro is included in the WSQLDDE.XLW workbook in the directory C:\SQLANY50\ACCXMP\EXCEL. You should start the database engine and the WSQL DDE Server before loading the workbook. You will see the sheet in Follow the instructions to clip data from the database and paste it on the sheet.