>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.
If it's not broken, fix it until it is.
My Blog