Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing whats on screen.
Message
From
21/12/2001 06:59:42
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00597160
Message ID:
00597200
Views:
16
>Any good books or threads on this you can recommend?

Microsoft Office Automation with Visual Foxpro (Granor & Martin) published Hentzenwerke. If you go to their site, you could buy/download the e-book version and get cracking right away. It is a really good start.

However, automating Excell is pretty easy. I found the CHM file that comes with Office "VBAXL9.CHM" (look in the office directory or on the office CD's) is a good utility to discover the XL object model.

Also, I did some fairly extensive XL automation (and Word) very recently and I was developing in VFP7. The Intellisense feature makes this a snap. A declaration of something like "Local oXL as Excel.Application" in the program/method and everytime to type oXL. in your program the XL PEM's just drop down in a list for you to select. Also, the Object browser in VFP7 is a real one <s> which you can explore things like Excess very easily.

Last thing, FoxyClasses have a class in their library which handles outputting VFP data to Excell spreadsheet (inc. memo fields too). Might be worth a look.
-=Gary
Previous
Reply
Map
View

Click here to load this message in the networking platform