Description: Description: Description: Description: Description: Description: Description: C:\Users\Graeme\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Word\Candy Technote-small.jpgVirtualized Office

Introduction

Candy can export to Excel using two methods. DDE is used for older documents. New documents and reports use OLE AUTOMATION.

Virtualized Office

Using App-V Office can be virtualized. Effectively this means that the actual Office products, such as Excel, are not run natively on the userís machine. Rather they are run on the server and a host program makes Excel appear on the userís machine.

This makes using traditional methods to connect to Excel impossible.

Making DDE work

This option is currently being investigated.

OLE automation

This will not work until Microsoft provides a method of connecting to Excel (or outlook).

Alternatives

An alternative is to export to Excel using CSV (XML can be used if it is going to be imported into Excel 2003).

If Outlook is virtualized then use BACKUP TO FILE rather than BACKUP TO EMAIL.