4specs.com    4specs.com Home Page

MasterWork Multi-File, Custom Macro Log Out | Topics | Search
Moderators | Register | Edit Profile

4specs Discussion Forum » Computers, the Internet and Networking » MasterWork Multi-File, Custom Macro « Previous Next »

Author Message
Guest (Unregistered Guest)
Unregistered guest
Posted on Tuesday, April 23, 2019 - 05:31 pm:   Edit PostDelete PostPrint Post

Has anyone else been having issues with the "custom macro" feature in the multi-file project tool in MasterWorks? I can get it to work with one file, but when I try on multiple files, it quits after running the macro on the first. Might be related to newer versions of MS Word. It's been a while now that it hasn't worked for me the way it used to. But it has been long enough I don't recall when it stopped working correctly. I don't use it very frequently, but it was helpful for those occasional times I needed it to save some time processing a batch of files.

I'm using Word for Office 365 (16.0.10730.20334) on Windows 10 and the latest MasterWorks plugin (downloaded today).
Jeffrey Wilson CSI CCS SCIP
Senior Member
Username: wilsonconsulting

Post Number: 283
Registered: 03-2006

Posted on Wednesday, April 24, 2019 - 09:00 am:   Edit PostDelete PostPrint Post

I have always found ARCOM's tech support very helpful, and the last issue I had under the Deltek regime held up to that standard. They will likely be able to solve this issue for you.
Jeffrey Wilson CCS CSI SCIP
Wilson Consulting Inc
Ardmore PA
Guest (Unregistered Guest)
Unregistered guest
Posted on Wednesday, April 24, 2019 - 02:26 pm:   Edit PostDelete PostPrint Post

I have the same issue with custom macros and they always tell me they are only responsible for their program, not any macro that I write. This is a recent phenomenon because it used to work correctly all the time.
Guest (Unregistered Guest)
Unregistered guest
Posted on Wednesday, April 24, 2019 - 03:21 pm:   Edit PostDelete PostPrint Post

Saying that they are only responsible for their program is more like a cop-out than like a comment from a company that cares asbout their customers. Clearly not a respone one would have received from the old ARCOM.
A customer oriented company would have helped you with the problem and hopefully found a solution.
Guest #1 (Unregistered Guest)
Unregistered guest
Posted on Wednesday, April 24, 2019 - 03:53 pm:   Edit PostDelete PostPrint Post

Guest #2's response is exactly why I haven't reached out to Arcom/Avitru/Deltek to solve this. They will simply claim that my macro is the issue. Although as Guest #2 says, this used to work correctly ... so it clearly isn't an issue with the macro.
David G. Axt, CCS, CSI ,SCIP
Senior Member
Username: david_axt

Post Number: 1786
Registered: 03-2002

Posted on Monday, May 06, 2019 - 08:05 pm:   Edit PostDelete PostPrint Post


I used the Custom Macro feature in the multi-file project tool and got the same results that you did. It runs the macro on one file then quits. There is nothing wrong with my macro. It is obviously a MasterWorks issue.

I will call Deltek tomorrow and let you know if I find out anything.
David G. Axt, CCS, CSI, SCIP
Specifications Consultant
Axt Consulting LLC
J. Peter Jordan
Senior Member
Username: jpjordan

Post Number: 1084
Registered: 05-2004
Posted on Tuesday, May 07, 2019 - 10:30 am:   Edit PostDelete PostPrint Post

I think it may be a Word issue, but I have not delved into it in any depth. The most recent versions of Word documents (as opposed to Word 97-2003 format) permit macros to be disabled by default. Again, I have not looked into this in any depth, but I think that may be the issue.

If this is the case, then Avitru might not be able to help.
J. Peter Jordan, FCSI, AIA, CCS, LEED AP, SCIP
Anne Whitacre, FCSI CCS
Senior Member
Username: awhitacre

Post Number: 1451
Registered: 07-2002

Posted on Tuesday, May 14, 2019 - 04:33 pm:   Edit PostDelete PostPrint Post

The latest version of Word/Windows is a little more skitterish than the older versions, and you may have to reset your permissions. We call Avitru regularly to re-establish some parameters. I realize that some of our issues have to do with our enterprise software, but the Deltek/Avitru folks work with a lot of different set ups, so they are often pretty knowledgeable.
Stan O. (Unregistered Guest)
Unregistered guest
Posted on Thursday, October 24, 2019 - 05:50 pm:   Edit PostDelete PostPrint Post

Was there ever anything found on this? We have the same issue with a macro running against only the first file of a multi-file selection.

Deltek/Avitru suggests uninstalling/reinstalling, but that produces no change in behavior. We have even tried on a fresh install of Windows, Office and MasterWorks and it still fails.

Deltek/Avitru's only other response is that they can't help with macros created outside of MasterWorks. The macro in question works, but the Multifile functionality doesn't. Unfortunately, we've found no way of getting Deltek/Avitru to troubleshoot the Multi-File/Custom Macro function since they always fall back to "can't help with macros created outside of MasterWorks".

Any guidance would be appreciated,

Guest (Unregistered Guest)
Unregistered guest
Posted on Thursday, October 24, 2019 - 09:13 pm:   Edit PostDelete PostPrint Post

Stan O. (Unregistered Guest)
Unregistered guest
Posted on Tuesday, October 29, 2019 - 03:10 pm:   Edit PostDelete PostPrint Post

Thanks for the response from Quora. However, I'm looking for a solution that allows a user to easily record some actions and apply them to a selection of files as the MasterWorks software previously did (not necessarily requiring our users to develop programming skills). Somewhere along the way the MasterWorks Multi-File Custom Macro function ceased functioning and MasterWorks support will not take ownership of it. My question was directed at finding a way to make this previously useful feature functional again. Have any MasterWorks users been successful in this regard?

Thank you,

Chris Grimm, CSI, CCS, SCIP
Senior Member
Username: chris_grimm_ccs_scip

Post Number: 516
Registered: 02-2014
Posted on Tuesday, October 29, 2019 - 04:13 pm:   Edit PostDelete PostPrint Post

Here is a one-time setup if you want to add this BatchMacro to your macros and then it will run any other macro on multiple files in a folder. I wrote this based on an idea from David Lorenzini to look into the dir function as a way to loop through files in a folder. Use at own risk yada yada but it has worked well for me for years. It's only as good as the macro and the files you're running it on!

Sub BatchMacro()

a = MsgBox("Runs a macro on multiple files in a folder. At the first prompt, browse to the folder and select any file.", vbOKCancel, "Batch macro")
If a <> 1 Then
End If

Dim JName, strpath, strCriteria, strMacroName As String
strpath = ActiveDocument.Path

strCriteria = InputBox("Use default wildcard *.* or enter different search criteria such as *.doc:", "Criteria", "*.*")
strMacroName = InputBox("Enter the macro name you want to run on these files:", "Macro Name", "")
Application.ScreenUpdating = False
JName = Dir(strCriteria)
While (JName > "" And Left(JName, 1) <> "`")
Application.Documents.Open FileName:=strpath + "\" + JName
Application.Run macroname:=strMacroName
ActiveDocument.Close SaveChanges:=wdSaveChanges
JName = Dir()
Application.ScreenUpdating = True

End Sub
Chris Grimm, CSI, CCS, SCIP
Senior Member
Username: chris_grimm_ccs_scip

Post Number: 517
Registered: 02-2014
Posted on Tuesday, October 29, 2019 - 04:26 pm:   Edit PostDelete PostPrint Post

An easy way to being recording a macro is Alt, t, m, r.

To see your macros and modify them, Alt-F8.

The built-in help system is great.

If there is a task you need to do which goes beyond that, several of us here are willing & able to help further.
Stan O. (Unregistered Guest)
Unregistered guest
Posted on Friday, November 15, 2019 - 05:11 pm:   Edit PostDelete PostPrint Post


Thanks for the macro that could potentially replace the MasterWorks Multi-File custom macro function. We may go that route ultimately, but are going to continue to try and get Deltek/Avitru to address the broken code that was introduced into MasterWorks software. We've narrowed the problem down to a change in the MWorks.dll some time in 2017. The Multi-file custom macro function works in the 2017 Q1 release, but not in the 2018 Q1 or any later release of MasterWorks and we don't have archive copies of any other 2017 releases to narrow it down further. Hopefully we can provide enough information to the Deltek/Avitru folks to get them to take a look at it.


Add Your Message Here
Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Options: Automatically activate URLs in message

Topics | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration