Hi,

I am currently working on a FileMaker document management solution and adding and removing watermarks is a requirement of the process. The documents are office documents mainly Word and Visio and will be kept in container fields within the solution. Right now the best i have come up with is a send event script with the CMD code:

start winword FilePath /mmacroname

This opens the word document and calls a macro that removes or adds a watermark and closes the file. This works OK for word but I have not been able to find a CMD equivalent for Visio that lets you call a macro. Furthermore, this solution will be hosted on FileMaker server so all users would have to have macros enabled. I am looking for another way of doing this or a plug in that could accomplish or help with the task. Any help or ideas are greatly appreciated. Thanks.

Daniel

Using an embedded macro in the document itself is not a good idea.  Whether it runs or not depends on the security settings on the client machine and you may or may not have full control over that.  Also, if you have an updated version of the macro, all older documents will not have it.

 

You are better off taking the code of the macro and putting it in a VBscript or Powershell file.  Those you can store in a container field to and export / run them as necessary, feeding them the right parameters.

Thanks Wim. This definitely points me in the right direction. I will just have to figure out how to convert the macro to VBS.