Hi Michel

I am working with a similar problem today, trying to automate the opendatasource() command to link with an excel file. (office 2003)

I am using VFP 8.0 SP1.

Were you able to come up with the correct syntax to make this operate correctly?

I am struggling a bit with this one myself...



I didn't see any replies to your message, sorry to reply with a question.


>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