MasterWork Multi-File, Custom Macro

Log Out | Topics | Search Moderators | Register | Edit Profile

Author Message Guest (Unregistered Guest) Unregistered guest Posted on Tuesday, April 23, 2019 - 05:31 pm:    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:    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:    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:    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:    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:    Guest, 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:    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:    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:    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, Stan Guest (Unregistered Guest) Unregistered guest Posted on Thursday, October 24, 2019 - 09:13 pm:    https://www.quora.com/How-do-I-automatically-run-a-macro-on-all-Word-files-docx-in-a-folder Stan O. (Unregistered Guest) Unregistered guest Posted on Tuesday, October 29, 2019 - 03:10 pm:    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, Stan 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:    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 End If Dim JName, strpath, strCriteria, strMacroName As String Dialogs(wdDialogFileOpen).Show 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() Wend 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:    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:    Chris, 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. Stan