I need the basics for the OLE Automation APIs for Excel and Word.
In case it makes a difference, I have Office 97. Googling did not
find me much. Any pointers would be appreciated.

Sincerely,

Gene Wirchenko

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

For VFP6, this would be a real good place to start since you don't have
Intelisense to help out.

http://www.hentzenwerke.com/catalog/autofox.htm

But what you can do is create a macro in Word/Excel, and convert that code
to VFP syntax. It's not all that different, once you get the hang of it.

You will need the main Application object to get started:

oWord = CREATEOBJECT("Word.Application")
oExcel = CREATEOBJECT("Excel.Application")

Fred
Microsoft Visual FoxPro MVP


"Gene Wirchenko" <genew (AT) mail (DOT) ocis.net> wrote

Only two Foxpro functions are involved: Getobject() and Createobject().

Beyond that, it's all up to Word and Excel.

You'll need their VBA help files. If memory serves, Office 97's "complete"
install isn't as complete as it may sound and didn't include the VBA help
files. You need to re-run setup and choose a custom install to explicitly
get the VBA help files.

Once that's done, open the VBA editor in Word (or Excel) by pressing
alt-F11. Once in there, press F2 to get to the object browser (or F1 to get
to help).

Dan

Gene Wirchenko wrote:

Gene,
In addition to what others have told you, check the MS knowledgebase. They
have some articles that will help you get started.

--
Bill Browne
www.edgefinderstudios.com


"Gene Wirchenko" <genew (AT) mail (DOT) ocis.net> wrote

Oh, and by the way....

I had an article in the July, 1999 issue of Foxpro Advisor that was all
about discovering what was available with automation.

If you've got 'em sitting around, you might find it useful.

Dan

On 2004-08-27, Fred Taylor <ftaylor (AT) mvps (DOT) org!REMOVE> wrote:
True expert in Foxpro doesn't need intellisense.


--
.~. Might, Courage, Vision. In Linux We Mutate.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.27
^ ^ 3:08pm up 19:48 1 user 1.00 0.98

So what's being an expert in FoxPro got to do with the automation models of
other products? <g>

Fred
Microsoft Visual FoxPro MVP

"toylet" <toylet (AT) hotpop (DOT) com> wrote

Gene ? You tried Google on your dial up conn and did not 'get much' ? I
sense you used the wrong search terms.

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.
what were you using for search terms in google, may one ask? [and expect
your answer?]

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?
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

"Gene Wirchenko" <genew (AT) mail (DOT) ocis.net> wrote

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

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.

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

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

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.

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.

we (I meant Foxpro programmers) don't need an automation model
We deal with data, not automation.
besides, what the heck is an automation model?

Fred Taylor wrote:

--
.~. Might, Courage, Vision. In Linux We Mutate.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.27
^ ^ 6:22am up 2 days 11:02 load average: 1.05 1.02 1.00