webax

how to open file from VBA

2 posts in this topic

Hello,

I try to access to filemaker file from VBA in outlook, with ActiveX automation

When the file is on my local machine, no problems.

Set myOpenFile = FMDocs.Open("c:\myfile.fmp12", "login", "password")

but I can't access to a file with IP adress ...

Set myOpenFile = FMDocs.Open("xxx.xxx.xxx.xxx\myfile.fmp12", "login", "password")

What's wrong ?

Thanks

Share this post


Link to post
Share on other sites

You can't open a remote file.  The ActiveX interface is limited to local files.  You can however open a local FM file that has a file reference to the hosted file and open it implicitly that way.

You can also use the FMP URL protocol to open a hosted file directly and not bother with the ActiveX interface.

1 person likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now