Christof

We get an Excel 2007 file with 5 sheets of different accounting data. I need to put each of them into a DBF. Since MS deprecated the Excel saveas DBF3 or DBF4, I have to find another solution. I have made saving to a CSV file work for data I know the structure of. For data I do NOT know the structure, I thought using XML would be straight forward using XmlToCursor. But once again, MS has every fileformat for the Excel saveas method except XML. If there is a better solution I am all ears. I do not know about XMLSS, but will check it out. Do you have any tips to shorten my learning curve?

I am very new to the Office 2007 automation process. I have several solutions using Office 2003 and before, but 2007's object model is confusing. I have not used XML but for one app. I hope the solution is NOT building the Excel to XML line by line. I feel that would be very primitive compared to the object models available. We are not using .Net for a solution, only VFP and the Office object model.

Thanks for your time, Chuck

>Hi Chuck,
>
>> I am having trouble using automation to create the excel 2007 xml file.
>
>I don't understand why you want to use automation to create the XML file? The beauty of the XML format is that you don't need automation and therefore everything is fast. In XMLSS the syntax to define a named cell is
>

> [Names]
>   [NamedRange ss:Name="whatever" ss:RefersTo="=Sheet!R1C2"/]
>[/Names]
>

>I don't know the OOXML syntax for that, as for Excel I prefer XMLSS for backward compatibility.