Jump to content

Running a Networked FM Script from VB


Shadowfax
 Share

This topic is 5723 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm trying to run an FM script from Microsoft Word VBA Code. While this is pretty easy to do if the database is local, I'm having trouble figuring out how to do this over a network.

The trouble occurs at the following VB line:

Set FMProDoc = FMProApp.Documents.Open(filepath, password)

Basically, it opens a database using the specified filepath and password, and then stores a link to that database inside the FMProDoc object.

Unfortunately, I cannot determine what filepath to provide for a database on a network. From Filemaker, I would normally go to "Open Remote", choose "Local Hosts", and pick the shared database I want from the list. Is there a filepath equivelant?

Thanks in advanced. }:(

Link to comment
Share on other sites

I don't believe you can open a remote file using VB(script) activeX. The workaround is to have a local opener file that gets opened by the VB Code, and then that file opens the remote file through a Scriptmaker script.

Link to comment
Share on other sites

I think Reed is correct. I messed around with this for a few hours one time and never got anything to work. I ended up going with the opener file method.

Maybe Wim can chime in. When it comes to Windows topics, Wim is the final authority.

Link to comment
Share on other sites

Ah, well... I understand. Having a local file opener is a good workaround, though it takes away from the whole "one shared file" simplicity.

Thanks again for the responses. If anyone has further comments/suggestions, I'm still listening.

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 5723 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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