This Week's Software Tips
Here's a money-saving tip from our own Tip Patrol member, Billy Wooten. He informed us that some blank CDs and DVDs on the market can burn at a higher rate than is normally used (52X for CDs and 16X for DVDs), but these media are incompatible with many older burners. Instead of buying another burner, access the manufacturer's Web site and search for a firmware update for that particular unit.
Billy advises us to follow the directions for downloading and installing the file because it's a little more complicated than a standard update (for example, Direct Memory Access must be disabled before installing). This update allows the burner to recognize the higher burn rate of the media. Although not all CD burners will have an upgrade (there are some physical limitations on the old ones), most can be updated to perform with the higher-speed media.
AutoCAD-to-Excel Table Link
Leonid Nemirovsky sent this AutoCAD 2008 tip for embedding two-way editable tables in AutoCAD by linking to an existing Excel file, with a few additions to the standard approach.
To create a table in AutoCAD 2008 from an existing Microsoft Excel file:
- In the Excel file, be sure that the text style in the cells is set to the font that's your company standard for use in AutoCAD (and with proper heights).
- In AutoCAD, initiate the Table command and set your desired table style (assuming you have several).
- Click on the From a Data Link button, then select Launch the Datalink Manager. In the Select a Data Link dialog box, select Create a new Excel Data Link. Type a name for the link and browse to and select your existing Excel file. If everything looks good, click the OK button, then OK again, and OK for the table.
Now you can do more with the table contents and linked Excel file. Click on the new table; it will look like a regular spreadsheet. At the cursor you will see the Lock Link symbol. Click in the upper left corner cell of the table to highlight rows and columns, then right-click the cell. In the popup menu, select Locking and Unlocked. Now you can edit table data in place. Right-click again in the pop-up menu and select Data Links and Upload User changes to Source File. Or, if you made changes in a linked Excel file and saved it, you can click Download Changes from Source File to update the table.
NOTES FROM CADALYST TIP PATROL: This is a very slick process!
Select Matching Blocks
Michael Weaver'sSelectTagsByExample.LSP (STBE) routine selects all blocks in the current drawing that match a selected example. He explains, "The example must be selected by an attribute, and this attribute is used to further filter the selection. Thus, selecting an insertion of a WallTag block with an attribute value of 4 will select all insertions of WallTag with attribute values of 4. After running STBE, the resulting selection set can be manipulated with the Properties palette or any of AutoCAD's other commands. STBE works on dynamic blocks."
NOTES FROM CADALYST TIP PATROL: A useful routine! Click on the Tag value, and all the similar blocks will highlight. In conjunction with the Properties Manager, this is a good way to change "like" attributes to another value.
Cleaner Drawings Button
David Rodriquez offers this suggestion to clean up drawings: "We create a toolbar button that, once in paper space, will zoom extents (usually the border), audit, purge with the dialog box (in case there are features you may want to keep), and set layer 0 current. Here is what it looks like:
^C^C_z e audit y _purge clayer 0 qsave
Nice little macro -- especially the selection of the dialog box purge. We also like the reset of the current layer to 0. Here it is in an AutoLISP routine that can be assigned to a toolbar button:
(defun c:DRclean (/)
(command "zoom" "e"
"purge" pause "" "no"
(setvar "clayer" "0")
Mark Northcott offers this simple solution when you need to change a particular line of text, even if it is hidden deep in a string of text. He writes: "Select all the instances of mtext you would want to change and go to Edit / Find. Use the Replace button to change a string or a word that you want to change. Just type in the word you want to replace and the word to replace it with, and you're done. This is a big timesaver that I know many people don't know of and don't use."
NOTES FROM CADALYST TIP PATROL: Good tip and very versatile, similar to Quick Select. Plus, this trick is more powerful than many realize. In global (whole drawing) selection mode:
- Find will work on both mtext and non-mtext entities.
- Find will replace text strings in both paper and model space simultaneously.
- Find will replace text strings in both mtext and non-mtext entities, in both paper and model space, even if they are frozen.
Import Page Setup
Michael Cipolla sent LMHT36X24PS.LSP, an AutoLISP routine that provides a way to update import page setups. He says: "We often work with drawings that come from out-of-office sources. It was always a time-consuming and tedious task to change/update all the page setups in the drawings. I have created LISP routines for all our different clients and sheet sizes. I have also created a pull-down menu with shortcuts to all these routines.
"These tools give my users a quick and easy way to create/update page setups in a drawing file. This makes for more consistent and easier automation. The routine will rename the layout tab to be the same as the file name; remove all page setups in the current drawing; and import all the page setups saved in the drawing file written in red and set the specific page setup written in blue to be current.
"Note: The drawing file needs to be within the AutoCAD Support search path. All of our drawing files use a single layout tab. To use this routine with multiple tab drawings, you would need to do some modifications."
NOTES FROM CADALYST TIP PATROL: Be sure to create a new page setup by right-clicking on the Layout Tab of the drawing being referenced. You may have to use forward slashes (/) instead of back slashes (\) in the path to the referenced drawing. Individual firms' usages may require more customization. The embedded plot configuration in this LISP program might be an issue for firms that frequently upgrade plotters.
Quick Text Styling
Perry Medina sent in these simple keyboard commands for quick text changes:
- Use Ctrl+Shift+U to change selected text to uppercase.
- Use Ctrl+Shift+L to change selected text to lowercase.
- Use Ctrl+U to underline selected text.
- Use Ctrl+O to overline selected text.
NOTES FROM CADALYST TIP PATROL: These are Microsoft Windows keyboard conventions that work in AutoCAD as well as other applications. They can be used in single-line and multiline text. Just be sure that the text is in edit mode and highlighted.
Shawn Samaniego offers TR.LSP, a routine that aligns any string of text to a line (nonpolyline) and also aligns blocks and other miscellaneous objects. He writes: "For those of us who still operate in AutoCAD 2006 and earlier, I have used this TR.LSP routine. I use it so much that I have included it in my ACADDOC.LSP.
NOTES FROM CADALYST TIP PATROL: Good tip and works great. It instructs the user to choose the line first (no polylines!), then the text (or mtext). The only weakness is that it will allow the user to select more than one line before the user hits Enter to go on to pick the text (or block) to be rotated. We suggest using a name other than TR (it's an alias for the TRIM command).
Note: These follow-up tips have not been tested by the Cadalyst Tip Patrol.
Follow-Up: Reverse Paging
Shea Greenleaf sends and addendum to the tip in the February 25 edition about paging backward through AutoCAD drawings: "You can also set the AutoCAD Taskbar environment variable to 1, which then displays multiple open drawings on the windows taskbar. This has the added benefit of being able to switch between open drawings in any order with a simple mouse click -- assuming the drawings are named in ways you can recognize.
Follow Up: Outside the Box
Several readers responded to Outside the Box, the tip in the February 25 edition about clicking outside the Mtext Editor box instead of clicking the OK button when finished editing mtext. Some AutoCAD users might prefer taking the keyboard approach: Ctrl+Enter. As Eric Fransen said, "Sometimes ya feel like a click, sometimes ya don’t."
Paul Dempsey added that many such hidden keyboard gems are available throughout AutoCAD. "For example, CTRL+F in the Mtext box gives you the Field dialog box -- quick and handy without the need to right-click and scroll through the menu. If you have a repeated command, look for the keyboard shortcut, or perhaps create one."
MicroStation Tip: Fun with Function KeysToday's MicroStation tip courtesy of Axiom and MicroStationTips.com.
Using function keys can speed up your MicroStation workflow. Here is a way to use function keys. As a refresher for the rusty (or an introduction for the neophytes), the Function Keys dialog box is under the Workspace menu.
Submit Your Tip for your favorite CAD software. If we publish your tip, we'll send you a Cadalyst T-shirt, and each month Cadalyst editors will randomly select one published tip and send a $100 gift card to its author. Please submit only code and other tips that are your original work (or provide the original source so we can include proper credit) and tell us which software version you use. By submitting code, you grant Cadalyst the right to print and distribute your code in print, digitally, and by other means. Cadalyst and individual authors retain all rights to the code; published code is not to be used for commercial purposes.
Tips & Tools Weekly software tips for AutoCAD are reviewed by Cadalyst staff and the Tip Patrol before publication. Use all tips at your own discretion, please, and watch later editions of this newsletter for updates and corrections. We're sorry, but editors and Tip Patrol members cannot provide assistance with technical problems; please refer to Cadalyst's Hot Tip Harry-Help discussion forum.Sincere thanks to our volunteer Tip Patrol members: Brian Benton, Don Boyer,
Mitchell Hirschklau, R.K. McSwain, Kevin Sawyer, and Billy Wooten.