Jump to content

how to open file from VBA

Recommended Posts


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 ?


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.

  • Like 1

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


Important Information

By using this site, you agree to our Terms of Use.