You can achieve something like the previous functionality by creating an extra hidden worksheet in the Excel workbook and then using Excel cell references within your template to replicate the data in the desired positions. So instead of writing directly to the cells using DDE you will write to an intermediate position using any of the standard ways of writing to Excel, and use Excel itself to update the template. Richard
... View more