Microsoft Office Automation using VFP7.0

[sumpun]

Does anyone know any good books for developing applications that manipulate word, excel and ms graph.

There is one at this link :

http://www.amazon.com/exec/obidos/ASIN/0965509303/qid=/sr=/ref=cm_lm_asin/002-6771909-8179251

The book is called "Microsoft Office Automation with Visual Foxpro".

However, it looks at VFP version 6.0. Is it done the same way in version 7.0 or are there differences ??

Also, does it make any difference if I use MS office 2000 or MS office XP, as I have to support both versions of MS office.

 

[danceman]

I sure what you can do with 6.0 will work in 7.0. Not sure about XP. But I have found that of all the books I have purchased to help me I have ofund that when they are published by Microsoft they are the best. I have one that handles ms office. I used it to automate office functions. They give you the best examples, they do not work by theory. Attitude is Everything

 

[Mike Gagnon]

sumpun

I think the the book you mentionned is probably your best bet. The differences between VFP6.0 and VFP7.0 in regards to Automation is probably slight enough that you shouldn't have any problems.
this link also has been usufull to me, to find object.

http://www.msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000550

 

[Steve Bowman]

for "MOST" automation functions I have found that if I do not know method or property to use in the Office app ie. Excel, Word I can do a quick macro record for what I want to accomplish the resulting VB code can with little conversion be used in VFP. The VB Macro code will use internal vars for most parameters however in the VB edit window you can right click -->description and look up the real value like xlBorderColor = -4105


I have found some difference on how Office2000 and OfficeXP do things you will need to create some version checking and write the code to account for version. Steve Bowman
steve.bowman@ultraex.com

 

[Walid]

The most two important deference between VFP6.0 and 7.0 regarding office automation are the Smart Tags and the Event Handlers. In VFP6.0 the office application can’t trigger an event handler meaning you can for example add send an E-mail using Outlook from VFP but your VFP application has no way to detect the mailsent event in Outlook.
Thanks to the new IMPLEMENT in the DEFINE CLASS, you can detect and trap event now in VFP. More than this as far as I know no much deference.

Walid Magd
Engwam@Hotmail.com