Christof
I have been successful in manually creating an excel 2007 xml file and using XmlToCursor (vfp8) to create a cursor. I am having trouble using automation to create the excel 2007 xml file. Macro creation does not include any clicks on the ribbon. Can the XML add-in be used if the user/client does not have it installed? Can you point me to some examples of the automation code that would show creating the xml file?
Thanks, Chuck
>Hi Albert,
>
>>In Word, I used bookmarks to "tag" a spot in the document and so as long as the bookmark exists, I can find it and insert text. Users can therefore continue to add or change text as long as they leave the bookmarks in.
>
>BTW, the same is possible in Excel. You can give a cell a name. Other sheets in the document can then refer to the cell by the name instead of "Sheet!A1" or something like this. That's useful if you just have simple values and no one to many relation (like invoice items).
>
>With XML or automation create a sheet that has all values in column A, one value each row. Then assign each cell a name. In column B you might have an explanation for each value for reference purposes.
>
>Your template should have a similar structured sheet in the workbook with sample data in there. All other sheets refer to named cells. This way you customer can continue to keep editing the template document. To generate the final document, all you need to do is to create a copy of the template and swap the sheet with sample values in exchange for the generated sheet with real values. That should be an easy task in automation or by using XML. All other sheets can remain unchanged.
Extreme Programming = Plan -> Design -> Code -> Test