OLE Automation

[SES Tech]

I notice that FileMaker installs a "tlb" file for filemaker which should mean I can access it thru VB. I've tried every combination I can think of for:

GetObject or CreateObject

in VB. Has anyone done this or know how?

[Wim Decorte]

Check out the help for "activeX", it details all the objects and methods plus has some VB examples.

You need to include a reference tot he LIB file in your VB project, use VB's object browser and you'll see FileMaker 7 listed.

In VBscript and the like this will work:

CreateObject("FMPRO.Application")

Note that this syntax is the same for FM6 so if you have both FM6 and FM7 installed this call will run whatever you last opened manually.

[SES Tech]

Thank you. Perfect. I looked at all the help files and pdfs on the Developer CD, but never thought of the help file. My mistake. The help file is indeed good.

[SES Tech]

Couple of cautions, for others:

A Script must be checked and visible in the Script Menu to execute

Can not open remote files

Solution: Use a "parent" file containing automation scripts and remote opens (as a script)