>I have two Office Automation Questions, One on Word and the other on Excel.
>
> In Word, if I issue the command oDocument.MailMerge.OpenDataSource('datasource.csv') , on some workstations it works fine, while on others it does not. They are all running XP and have all the office service packs up to date and the compatibility patch installed on both. Any insight as to why some do not work?
>
> In Excel, I copy data from a table in VFP as an .XL5 type because the .XLS type has a restriction of a certain number of rows it will copy. After I am done with what I do with the excel sheet, is there any way to save the workbook in a newer format without the prompt asking if the user wants to convert it to the newer format (as it does when the user would save it manually). I know the commands for save and saveas, but they do not automatically convert to the newer vesions.
>
>Thanks.

I believe SaveAs allows to specify version format. Also add DisplayAlerts = .f. for Excel object.
The three chief virtues of a programmer are: Laziness, Impatience and Hubris. (Larry Wall)

My Blog

PluralSight Learning Library

I have seen many references to the file format having 41 types, but I can not find them in the help menu as it states or anywhere on the internet. Do you know where I can find the list of syntax for the file formats?