We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

how to open file from VBA

Recommended Posts

webax    0


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
Wim Decorte    443

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 Guidelines.