Excel to draw in AutoCAD
Excel to draw in AutoCAD
(OP)
I am looking to produce profiles, cross sections etc in AutoCAD by inserting a line of commands from an excel spreadsheet. How exactly is it done?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Excel to draw in AutoCAD
RE: Excel to draw in AutoCAD
Is this similar to what you are trying to do?
RE: Excel to draw in AutoCAD
RE: Excel to draw in AutoCAD
From your Excel WB:
1: View > Toolbars > Control Toolbox
2: Select the Command Button from the toolbar and
draw one on the worksheet
3: Double-Click the button (fires up VB Editor)
4: Add this code
Sub RunAutoCADCommands()
Dim iRow As Long
Dim sCmd As String
'Connect to AutoCAD
Dim cadApp As Object
Dim cadDoc As Object
Set cadApp = GetObject(, "AutoCAD.Application")
Set cadDoc = cadApp.ActiveDocument
'Issue Commands
iRow = 1
Do While Range("A" & iRow) <> ""
cadDoc.SendCommand (Range("A" & iRow))
iRow = iRow + 1
Loop
'Done
MsgBox "Done Processing Commands"
Set cadDoc = Nothing
Set cadApp = Nothing
End Sub
NOTE: This processes all commands in column A, starting with row 1. Modify as needed.
5: Switch back to the worksheet. You can highlight the button, select Properties from the toolbar to change the name displayed.
6: Exit Design Mode (a button on the toolbar)
7: With a drawing open in AutoCAD, hit the button.
Hope that helps...
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Excel to draw in AutoCAD
Private Sub CommandButton1_Click()
End Sub
Just put the code in this sub, rather than RunAutoCADCommands().
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Excel to draw in AutoCAD
If I understand you correctly, you have columns for an X & Y coordinate points. There is a simple way to paste these into Acad to create a pline to draw a cross-section or profile that doesn't involve lisp routines.
1) using concatenate or & in excel create a column with "x,y" in a text format. (eg. =A1&","&B1)
2) copy the entire column for the profile or cross-section
3) start a pline command in Acad
4) go to the text window (F2), under EDIT hit PASTE.
cross-section drawn.
RE: Excel to draw in AutoCAD
For example:
Using Excel as a database which can update drawings that have the associated links through the blocks.
Idea is that what you update in excel, it will update all the other drawings where blocks are linked to the excel. Similiar to the Xref.
another example
-Excel Data Sheet
|
- Drawing 1 _ Plan Drawing
|
- Text linked in a block attribute to Excel Sheet
- Drawing 2 _ Profile Drawing
|
- Text linked in a block attribute to Excel Sheet
- Drawing 3 _ Details
|
- Text linked in a block attribute to Excel Sheet
- Drawing 4 _ Tables
|
- Text linked in a block attribute to Excel Sheet
All Driven by Excel and Attribute Blocks.
Maybe the block setup could be a genearic type block. All we need to put in the attribute area is the approperate Excel Cell (A11) and that value will show up in the autocad block attribute drawing.
RE: Excel to draw in AutoCAD
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Excel to draw in AutoCAD
thanks...
RE: Excel to draw in AutoCAD
DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
RE: Excel to draw in AutoCAD
http://www.geocitiesdotcom/flores_2793@sbcglobaldotnet/Points.xls
Start a new drawing, then copy what is in the red box only and paste it at the command line. By seeing how this is done, you can get an idea of how to draw other things from Excel.
Flores
RE: Excel to draw in AutoCAD
RE: Excel to draw in AutoCAD
but
can autocad attributes be linked to a ACCESS database or excell...
I know if you paste the excel cell into autocad and you go to plot... looks pretty crappy... but if its in a block its clean..
any ideas?
RE: Excel to draw in AutoCAD
Visit above site then u can find out what u want.
That is what exactly u want !
Unlucky it is written in Korean !
So I just wish there is Korean friend near u ~
That public free software can only operate in ACAD 2000
Made it with LISP !
RE: Excel to draw in AutoCAD
RE: Excel to draw in AutoCAD
Download these programs...
ExCAD2004 to pass the spreadsheet Excel to AutoCAD...
ExCoorCAD2004 to pass coordinates of a spreadsheet Excel to AutoCAD...
ExCAD2004 = http://speedcad.webcindario.com/descargas/ExCAD2004.exe
ExCoorCAD2004 = http://speedcad.webcindario.com/descargas/ExCoorCAD.exe
Un saludo de SpeedCAD... :)
CHILE
RE: Excel to draw in AutoCAD
Link is not working again...