In a VFP procedure, I merge a Word document with an Excel data source.
In my Word document, I put some merge fields in the header and the footer.
It works fine with VFP7/8 and Office XP.
With Office 2003, the merge fileds in the header and the footer do not merge.
In the final document, they look like the merge fields expressions (i.e. «CompanyName» instead of the name in the database).
However when I open the Word document and I merge it manually with the same Excel data source, it works fine.
the command line to open the Excel data source I used is :
OpenDataSource("C:\FOLDER\EXCELSOURCE.XLS", 1, .F., .F., .T., .F., "", "", .F., "", "", "", "SELECT * FROM `EXCELSOURCE$`", "")
Thanks in advance for your help.
Stéphan Laporte
slaporte@analystik.ca