Can scriptmaster do this?

[Jackson Ben]

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.

[Jackson Ben]

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.

[comment]

I am curious what does the VBA script do that cannot be done natively inside Filemaker?

 

--
P.S. Please update your profile to reflect your version and OS.

 

Edited August 21, 2016 by comment

[Wim Decorte]

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.

[Wim Decorte]

See: 

 

 

[Lee Smith]

Hi Jackson Ben and welcome to the FMForums,

I merged your two questions, please don't double post your questions.

If you haven’t already read this article by Ocean West, please do so now.  Anatomy of a Good Topic,

TIA for your cooperation,

Lee

 

[ryan360Works]

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 .