Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Office Automation Questions
Message
 
 
To
29/09/2010 15:53:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01483222
Message ID:
01483254
Views:
53
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform