I have many lines or other primitives (circles, squares, etc...) I need to create information about this, such as, line is a street, so I need to write many information about all lines (such as street name, category, construction ...)
Is it possible to convert acutcad dwg for eg closed rectable polygon to standard primitives like box object.
I want to give length, width and height segment after extruding the 2d dwg rectangle object is there any method. coz if i texture dwg extruded object the tileing is not fixing properly, but if i texture in 3d box standard promitives object , the x and y tileing is coming exactly I want ?
Recently I have been trying to build table driven products and ipart tables, but when I copy a member to create a new part number, upon exiting the iassembly author I get the following message "excel installation is required for this operation. failed to launch excel". I have a fully functional version of 2010 Excel installed which has been used so it should be recognized in the windows registry. I am running Windows 8 and Autodesk Inventor 2014.
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
We have a whole bunch of spreadsheets that we use for calculations and parts of those spreadsheets are linked to a ton of CAD Drawings via data links.
We would like to be able to deliver the CAD drawings to the client without having to send our calculation books (just the output tables). In other words, is it possible to embed the table data and remove the excel link for the final delivery?
I'm running AutoCAD MEP 2012.The user with the problem is running AutoCAD 2012.
We have a drawing with an excel spreadsheet pasted into the Paper Space as an embedded OLE object. I open the drawing and it prints fine. When he prints the drawing, the spreadsheet is very grainy and hard to read.
I tried plotting to a PDF and several different printers with same results every time. The only difference I noticed about his Plot Dialog Window was in the "Shaded Viewport Options".
When he selects from the "Quality" dropdown, the values for DPI associated with each option are different than mine. For example, on "Quality" setting "Normal", my window shows 300 DPI and his shows 100 DPI.
I tried setting his to "Custom" with a value of 300 DPI, but it seems to have no effect.
May be unrelated, but I also noticed that his LWDEFAULT system variable somehow got set to 09. I had to set that back to 25.
Well I had a day and a half trying to figure out how to bring Excel data into LT. Again. Here is what I have found out:
Running Excel 2010 I have a xls files (of type '97-2003 xls - file includes VBA). The file spits out a ton of data that I want to put in a schedule in AutoCAD. The schedule format needs to match our standard format - RomanS in white and blue.
If I copy and paste as a link the font remains stuck as Arial (regardless of source font) and can't be relaxed unless you go one cell at a time in the text editor. Also the resultant table size is tiny -
If I save the file to .XLSM (macro enabled '10 excel file) the results are the same. If I save the file to .XLSX ('10 excel file and ditch the VBA project) the results are sublime - the font is ok and I can go back and forth from AutoCAD to my now broken spreadsheet because VBA IS MISSING! The resultant table size is tiny but I can deal. I don't see how AutoCAD can work with xlsx but not xlsm.
I also found that if I save the sheet (values only) as a .csv file I can use that to create a table from file without font overrides screwing everything up.
I'm running AutoCAD LT 32bit on a Win7 32bit OS. My Office version is 2010. I would like to link data to a '97-'03 version of an xls or an xlsm without having the font overridden to Arial.
I am linking a model to an excel spreadsheet. Normally you would specify what cell on the first sheet (Sheet1) to start in. I have been told that you can link to other sheets in the workbook as well. Is this possible? I have tried, but have not been successful. If it is possible, how is it done?
I am currently working on a project where I am taking a lot of Autocad Attributes and Exporting them to an excel file so they can be referenced in a table of contents type of manner. My question is if there is a way to have excel automatically update the tables after changes are made to the autocad file. This file is an ever changing thing so going back and running through the entire "Eattext" command and re exporting and overwriting the existing file is very tiresome, especially when I am adding and deleting attributes daily. Is there a VBA program I can run to accomplish this task, I have fairly limited VBA skills and haven't written in VBA for years. I am fairly new to exporting autocad attributes to excel . I attached a very simplistic example of the general Idea of what I am trying to accomplish.
I saw a youtube video "Cross Section in AutoCAD".But i could not understand how to transfer the data from excel to AutoCAD.There is a file TMaker.exe to make template of excel data.I could not find that elsewhere on net. Making earthwork x-sections with AutoCAD.
I am trying to insert tables into AutoCad from excel the problem that I have is with the text style.
Every time I copy and paste as a linked AutoCad entity the text does not come across as the correct text style - for example if I want the table text to come out as ISOCP it comes across in a bolder text, requiring me to enter in the cell and select ISOCP I don't have to highlight the text in the cell i only have to enter inside the cell.
I have a program that I used years ago to extract attributes from AutoCAD into excel. The VBA program is in excel. It is Attribute extraction Utility for AutoCAD Release 14. I want to use it again for 2014 but when I run it I get a compile error can't find project or library and it highlights the the following code "set doc = ACAD.ActiveDocument". Below is the entire VBA sub routine.
' THIS EXTRACTS THE ATTRIBUTE VALUES FROM AUTOCAD TO EXCEL
Sub Extract() Dim sheet As Object Dim shapes As Object Dim elem As Object Dim Excel As Object Dim Max As Integer
I have a favor to ask. In my drawings i have two distinct layer names (Say "ew" and "ns"). On these layers i have numerous plain text numbers in 5mm increments which are repeated many times throughout the drawing. What i would like to do is be able to start a VBA macro, have it ask the user to select an area by window on the drawing file, and have VBA look up and count the sum of all instances of each number occurring in the selected window. Then dump them into an excel spread sheet which i will then manipulate from there. An example output would look something like below: "NS" Layer Quantities... Height 25 30 35 40 45 and so on Total 56 33 62 39 50 "EW" Layer Quantities... Height 25 30 35 40 45 and so on Total 56 33 62 39 50 The ouput would require two rows of information. The top number would be the number on the drawing as text item and the lower row would be the total number of times that number appears in the selected area.
I am trying, to make a data extraction with Link External data with linking to a excel sheet. Everything works fine, with the data extraction.
Then I try using upload to source/download to source update, but end up with this msg. every time:
1 object(s) found. 1 data link(s) do not allow their data to be written out. 0 data link(s) written out successfully.
I have tried when it said, successful all the way, but nothing have happen in the excel sheet at that time.
What I am trying to do, is make it automatic or manual update in the attributes in the drawing. If I change something in my excel sheet and ofc. the other way around to if possible.
I have a drawing with so many rectangles in one layer. i want the sizes of those rectangles( ie L x B) is there any way to get the sizes of a rectangles from autocad and paste it into excel.
I've to put some data as like table beside the figure. I've these data in a excel sheet. Can i import that sheet in CAD? or I need use table and re-type all data?
In a machine shop environment, the current practice is for an admin person to review the drawing, then take down all dimensions and enter them manually into Excel. Is there an easier way to export data to Excel so that I can have the dimension reports rather than doing them manually. The second question is on the ability to save the document as a .pdf, although I think this is possible.
I have used Paste Special to insert an excel schedule into my AutoCAD drawings. When I try to print to Adobe PDF the excel schedule disappears. When I print to DWG to PDF the schedule is there but the text is really heavy and the file size is extremely large. This is causing a problem when combining PDF drawing sets, the files crash. why when I try to print an excel file to Adobe PDF that the schedules disappear?
I work for a company who's trying to automate the production of their mechanical and electrical cad drawings. We eventually want to integrate this into our website, so that a customer can select a few options, and a detailed drawing is generated based on what they pick.
To begin with, I'm trying to integrate AutoCAD with MS Excel. I've managed to automate in excel the options a customer can choose from. Now, the tricky part is, how can I transmit information to AutoCAD to perhaps pick blocks and strategically place them in specific locations of the drawing.
For example, if I have the option of Cats, Dogs, Elephants and Monkeys, and I have the option of quantities... 1, 2, 3, 4, 5, and I pick 3 Monkeys and 2 Cats, I want CAD to be able to place 3 monkeys and 2 cats side by side in a row.
I'm trying to import an excel table into autocad. I can copy paste using ole and that works fine. It prints well, but when I print it as a PDF the file is not legible.
I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.
I'm trying to do a spreadsheet inside a drawing. Trying to use fields because I believe they behave better with feet and inches than excel (without jumping through hoops)
I am looking for a quick way to take x,y coord. from excel and import them into autocad. I have read something on the MULTIPLE POINT command but every time I go and put the space in between the words it enters in multiple then point. I only have 10 data points but a lot of sets of points.