Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company.
Learn more about Allen...
Victor Ammons asked for help on importing information from Excel into AutoCAD. He reports that when he tries to import a worksheet, anything larger than what will fit on an 8.5x11 page is cut off by AutoCAD.
This problem is documented at the AutoCAD Web site, here:
The problem, it seems, is related to the fact that when you import a workbook, only a picture (a metafile) of the worksheet is included. This picture apparently only includes only the first page of the first worksheet in the workbook.
The AutoCAD Web page, referenced above, includes a couple of ways that you can get around this limitation. (They don't list what is perhaps the best solution--to upgrade to the latest version of AutoCAD.) The problem, in many ways, sounds very similar to a problem importing Excel worksheets into PowerPoint, as described in this Knowledge Base article:
In any case, the problem seems to be that AutoCAD is importing the worksheet as a picture. If you only want the worksheet's data--not a picture of the data--then you may consider getting the information into AutoCAD in a different way. For instance, you might export the Excel data in CSV format (which is plain text) and then import it into AutoCAD. Other intermediary formats may also fill the bill, but some experimentation may be necessary.
One ExcelTips reader suggested following these general steps to make sure that the data is pasted properly in AutoCAD:
To get the Excel data into the CAD model at the right size, it is necessary to zoom the model to the correct size before you paste the Excel data. The simplest way is to attempt the paste the first time and mark the width that you require by holding a piece of paper against the screen and marking the width of the floating paste area on the paper. Then, escape and zoom the model to the required size and then paste the data.
A final possible solution is to look into using a third-party program to handle the conversion of Excel data and its placement in an AutoCAD drawing. There are a number on the market, each with different features and strengths. You should be able to turn up a number of good candidates by doing a quick Internet search.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2992) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!