Hi,

This is my first question in the forum and I was wondering if anyone knew the answer. For the past 8 years or so, I have been using OLE to transfer information between perl and excel and word. I actually wrote a word version today for the first time in a long time. I am currently using the 2003 versions of excel, word and powerpoint. Powerpoint is the most arcane. One of the things I discovered is that I can go from perl to excel (via OLE) and then cut and paste (through perl) via MS-Graph/OLE to powerpoint. The nice advantage of this backwards and complex way of doing things is that it makes the graphs in Powerpoint native - that is, they are not embedded excel objects and can be edited natively in powerpoint. If anyone wants to know how to do those things I can demonstrate.

However - and here is the big thing - I have for the first time in 8 years experienced a problem with this process. I have found that occasionally I get the message "can't empty clipboard" and instead of the graph in powerpoint I get the variable (the handle) in perl appear in the place. That is, instead of a graph I get text saying something like "$$fh->{value}=$handle;" - really, that's what appears.

So my question is, has anyone been working with Office 2007 and XML to transfer data to MS Office? If so, can you direct me to some resources so that I can replace OLE with XML? I have scoured the net and found very little. Maybe if I figure it out, I'll write a book - haha.

Thanks,
Mike