Scan through multiple drawings to rename and change properties
JTB Batch Change brings the AutoCAD ActiveX Object Model to your command via Excel design spreadsheets. Some examples of feature commands are:
And many more.
Open JTB Batch Change (version).xlsm Microsoft Excel Macro Enabled workbook in the application install folder (at %appdata%\Autodesk\ApplicationPlugins\JTB Batch Change.bundle\Contents), you will find 7 spreadsheets:
The rest are 5 working spreadsheets:
Note: If your source linetype contains shape, you should have the shape definition .shp file in your AutoCAD support paths.
This application works best with latest Microsoft Excel version.
To ensure Macros will run, you should give them permission first: Go to Excel Options > Trust Center > Macro Settings > Choose "Enable all macros ..."
Then, the working flow is:
Your drawings are always backed up before any change is made. If any error happens, you can click to open BackUp Location to find and restore old your drawings.
For more information on how it works, how to use Find and Replace formulas, you can browse these pages:
The installer that ran when you downloaded this app from Autodesk Exchange is a custom installer compiled by JTB World.
To uninstall this app:
1st: You have to manage keep and/or remove files in your BackUp folder manually. You will find them at %AppData%\Autodesk\ApplicationPlugins\JTB Batch Change.bundle\Contents\BackUp folder. Here is where all your drawings are saved before being modified.
2nd: Goto Control Panel > Programs > Programs and Features (Windows 7/8/8.1/10) or Control Panel > Add or Remove Programs (Windows XP), then click uninstall.
You can use JTB Batch Change trial license for evolution and educational purpose only. The trial license is limited to work only with drawing that has less than 700 objects in model space.
Open Help worksheet to get your computer ID number. Send that number to JTB World for Activation Code. When receiving the Activation Code paste it into the cell C5.
You can also activate JTB Batch Change by open an executive worksheet, press Run, then press Activate button at lower left corner of the invoked window.
Once activated, JTB Batch Change will work on all drawings without any limitation.
It is recommended to open AutoCAD first before run Batch Change process
While the application is running, please don't try to use AutoCAD. Escape all active commands in AutoCAD and wait for the process to finish.
JTB Batch Change can work in all Excel language packs. But if AutoCAD is non English, it can get into error if the open process of your drawing is interrupted by AutoCAD alert, for example, "Drawing is created by non Autodesk application" alert.
If your memory is low, large drawing with proxy objects can get error after save. The application will automatically switch to ObjectDBX Disabled Mode, which runs slower, but safer.
Add ObjectDBX Disabled Mode to process drawings with proxy objects if Save Error happens in Normal Mode.
Fix bug in Import sheet - Find Value formula.
Add Xref Layer object.
Fix bug in Owner Name (the owner block's name) of Attribute Reference.
Add Width Factor and ObliqueAngle properties to Text, Attribute and Attribute Reference objects.
Fix bug in Owner Name filter.
Fix bug when hidden rows are included in drawings and commands selection.
Text replacement function upgrade.
Added support for AutoCAD® 2017
No change in version number.
Replace Log Window by Log Spreadsheet.
Fix bugs for working with Excel language packs other than English.
Minor bugs fixed.
Minor bug fixed.
Drawings backup folder is set to one place, and can be change via Help worksheet.