October 10, 2021 - Replicator has been updated!
A Map Columns button has been added to the new version of Replicator. It makes mapping your {data columns} in the macro SUPER easy! It also simplifies the preparation of your macro for Scrolling Windows (Sales Orders, Purchase Orders...) See the version history below to see all of the changes in the new version. Enjoy!
Combined with Word's Mail Merge capibilities, macros are a great way to make mass updates in GP. This method for years with much success, but I have been frustrated by this process many times:
If you haven't done much with mail merge and macros, this all may seem a bit odd and you may be saying to yourself, "What's the deal... what is he complaining about?" But if you have used mail merge and macros, hopefully (and unfortunatly) you can releate to what I am saying. Instead of complaining about it, I thought "Hey, I'm a Software Engineer... I can fix this and make it better and simpler!" So, I have created an Excel spreadsheet (Replicator.xlsm) that you will hopefully find helpful and easy to use.
Replicator.xlsm Excel file. Version 1.1.0.1 October 10, 2021
GPUG - Macros to the Rescue.pptx Version 2020.10.08 is the instruction file for Replicator.xlsm. This PowerPoint slide deck is large (around 200 MB) because it contain embedded video demonstrations.
GP Macro.xml Right click and save as. Custom colors for GP Macros in Notepad++ (It doesn't seem to be a valid xml file, but Notepad++ likes it)
Notepad ++ - free text editor
Version | Date | Features | |
---|---|---|---|
1.1.0.1 | October 10, 2021 | Start the data column name with a ~ to prevent Replicator from prefixing quotes (') in the data with a ~ | |
1.1.0.0 | October 15, 2020 | Added Map Columns to easily map data columns into the macro Fixed bug that occurred if a ' or ~ was in the data. Repositioned the Clear Data and Reset Data buttons Updated "Freeze Panes" so the top of data table is always visible Renamed "Header Rows" to "Header Lines" | |
1.0.1.0 | August 12, 2019 | Added "Data Table Name" so your data table can live in a different location (worksheet or workbook) | |
1.0.0.3 | June 12, 2018 | Minor changes/fixes | |
1.0.0.2 | January 29, 2018 | Major Update! Added MaxRecordNumber and changed UI layout | |
Prior | October ??, 2017 | Initial release... Please upgrade! :) |