Jump to content

Can scriptmaster do this?


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

Recommended Posts

  • Newbies

Hello, 

I'm new to scriptmaster, FM, Java, Groovy.

I would like to know whether scriptmaster can help me do this.

 

  • get valves from filemaker.
  • open an specified excel file.
  • input the values into predefined cells
  • Run a VBA script.
  • Get values from excel cells
  • input the values into filemaker field

Right now I manually opening the excel, input the values filemaker, run VBA script and input the cell values back to filemaker.

 

Please give me a sample if possible.

Link to comment
Share on other sites

  • Newbies

Hello, 

I'm new to scriptmaster, FM, Java, Groovy.

I would like to know whether scriptmaster can help me do this.

 

  • get valves from filemaker.
  • open an specified excel file.
  • input the values into predefined cells
  • Run a VBA script.
  • Get values from excel cells
  • input the values into filemaker field

Right now I manually opening the excel, input the values filemaker, run VBA script and input the cell values back to filemaker.

Im using 

  • FM14 pro advanced
  • 360works portfolio bundle
  • Office 2013 installed.(includes MS excel)
  • VBA script involves opening few more applications and generating documents. (15-20sec)

Please give me a sample if possible.

Link to comment
Share on other sites

I would suggest you don't embed the VBA code in Excel but keep it natively in FM and output it there as VBscript or other Excel-compliant code.  That way all of your master code will be in one place and you won't have pieces of your overall routine scattered in two different places with all the versioning maintenance that comes with that.  Not to mention the security hassle of having VBA code executed securely.

But to Comment's reply: agreed.  Chances are that whatever is done in Excel can be done in FM without the side-trip.

Link to comment
Share on other sites

Hi Jackson Ben,

I recommend that you take a look at Scribe . It is included in our portfolio bundle. It can write values from FileMaker to a predetermined cell in Excel and can also read values from an Excel sheet and write them into FileMaker fields. As far as samples go, there are a few example files included in the download for Scribe that should give you a good idea as to how the process works. I also recommend taking a look at the documentation to familiarize yourself with the function and how they work. Specifically, look at ScribeDocWriteValue and ScribeDocReadValue

Link to comment
Share on other sites

This topic is 2790 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
×
×
  • Create New...

Important Information

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