Sample Code Demonstrating DDEPoke and POKE()

MORE INFORMATION

Visual Basic for Applications

To successfully use DDEPoke, place the text ("Hello World!" in this example) in a cell and reference the range object with DDEPoke. For example, if Sheet1!A1 contains the text "Hello World!", use the following command:

   DDEPoke chan, "MyBookmark", Sheets("Sheet1").Range("A1")
				

Note that the following command will fail because the Data argument is a string:

   DDEPoke chan, "MyBookmark", "Hello World!"
				

Microsoft Excel 4.0 Macro Language

To successfully use POKE(), place the text (in this example "Hello World!") in a cell and reference the cell with POKE(). For example, if Sheet1!A1 contains the text "Hello World!", use the following command:

   =POKE(chan, "MyBookmark", Sheet1!A1)
				

Note, however, that the following command will fail because the Data argument is a string:

   =POKE(chan, "MyBookmark", "Hello World!")