VFP 6: OLE Automation: Excel and Word

#11

"man-wai chang" <toylet (AT) hotpop (DOT) com> wrote

Quote:

besides, what the heck is an automation model?

That's your "application interface" to control the other application through
code from VFP.

Fred
Microsoft Visual FoxPro MVP

#12

Hi Gene
I've never seen the programming language in the Office applicatons referreed
to as an API. Try Excel language, Excel macro, Excel VBA, Excel reference
"Gene Wirchenko" <genew (AT) mail (DOT) ocis.net> wrote

Quote:

"EFG NewsPost" <vfoxpro (AT) efgrip (DOT) bob.net> wrote:

Gene ? You tried Google on your dial up conn and did not 'get much' ? I

1) Well, I had the naive idea that the information that I found
should be usable.

2) 100,000 search results does not really help.

sense you used the wrong search terms.

No crystal ball needed for that. Sometimes, there is no set of
search terms that will do it.

USE
'vfp automation word'

and you'll find all the references you need.
This is one of the bibles:
http://www.civilsolutions.com.au/hwb...tofoxtable.htm
and it came up on page ONE.

I knew about this book, and I will probably end up getting it. I
was hoping to find usable basics on the Web.

what were you using for search terms in google, may one ask? [and expect
your answer?]

VFP Excel API

Hindsight is wonderful, but it always comes after.

In another (unrelated) search that I did for information on a VB
Basic TCP/IP control, I came across many sites with the same incorrect
information. No one seemed to have it right, this despite many
searches. Finally, I bothered the busy programmer who had handed the
control to me. The conversation went something like:
Why are you doing this?
That is what the documentation I have found on the Web says.
No, you do this, this, and this.
and lo and behold, doing what he said worked. No thanks to the Web on
that one.

This one seems pertinent to your 'dev' environment [vfp6/off97]
http://home.att.net/~john.harvey/vfpstuff.htm

snogs round the ankles [Bill]
--
ps - are my search terms better than yours?

If they work. One hit was reasonable. I will keep your set in
mind when I dig more deeply into this.

There is a reason why there is something called "library
science". Librarians get degrees in it.

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

#13

"Anders Altberg" <x_pragma (AT) telia (DOT) com> wrote:

Quote:

I've never seen the programming language in the Office applicatons referreed
to as an API. Try Excel language, Excel macro, Excel VBA, Excel reference

I am after the calls not the language. I will be writing my code
in VFP, not in Excel, Word, or whatever. That is why the term "API"
was natural for me to use.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.

#14

Gene - I have had a lot of experience integrating both Word and Corel into my
products. First and foremost, less automation is better because automation is
buggy. But, if you insist on more, you can always create a word macro, look
and the commands and they are the same when doing automation. The best way is
to create a merge data file in VFP and then let Automation merge the two files.

Regards,

Mike

#15

I am looking for some info on this subject. I have this book and have
successfully automated word with Foxpro. However, we are upgrading to
Word 2003 and the mail merge in these latest version(s) does not work the
same way. Can anyone confirm this? Is there a book that's more current I
can use?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

VFP 6: OLE Automation: Excel and Word

comp.databases.xbase.fox comp.databases.xbase.fox

Re: VFP 6: OLE Automation: Excel and Word - 08-29-2004 , 12:24 AM

Re: VFP 6: OLE Automation: Excel and Word - 08-29-2004 , 12:11 PM

Re: VFP 6: OLE Automation: Excel and Word - 08-29-2004 , 10:24 PM

Re: VFP 6: OLE Automation: Excel and Word - 09-09-2004 , 12:13 AM

Re: VFP 6: OLE Automation: Excel and Word - 09-29-2004 , 09:41 AM