linking Excel to AutoCAD

[domnita]

Good morning!

My designer and I have a little predicament. We built a bill of materials in Excel and we want to be able to import it in AutoCAD for all the drawings we are creating and we also want the respective drawings to get their respective BOM's modified if we change the original one in Excel.

Can anyone give us an idea? We would really appreciate it!

[blads]

G'day Domnita,

congratz on your first post...

if you use the advanced search facilities that may help... otherwise check out this thread

[andy.manninen]

Good morning!

My designer and I have a little predicament. We built a bill of materials in Excel and we want to be able to import it in AutoCAD for all the drawings we are creating and we also want the respective drawings to get their respective BOM's modified if we change the original one in Excel.

Can anyone give us an idea? We would really appreciate it!

/SNIP
To link objects in a drawing

1. Start the source application and open a document.

1. <LI class=list_1 value=2>Select the information you want to link and copy it to the Clipboard. <LI class=list_1 value=3>Open the drawing. <LI class=list_1 value=4>On the Edit menu, click Paste Special.
2. In the Paste Special dialog box, click Paste Link.

Paste Link pastes the contents of the Clipboard into the current drawing and creates a link to the file in the source application. If you click Paste, the Clipboard contents are embedded instead of linked.

1. In the As box, select the data format you want to use.

1. Click OK.

Command line PASTESPEC
/SNIP right out of AutoCAD help!
:Cheers:

[domnita]

G'day Domnita,

congratz on your first post...

if you use the advanced search facilities that may help... otherwise check out this thread

Thank you!

[domnita]

Thank you Andy. I'll get my designer to try that.

Thanky!

[Opie]

Hi domnita

Please note I have *moved* this thread from the New Forum Users Forum to this one as I believe it would be better served here.

Below snippet is from the small print on the Forum General page -

<snip>
New to the Forums? This is the place to experiment with the posting editor and learn how to interact with our forums. Please experiment here with forum features and commands.
</snip>

Thanks,

Richard
Forum Moderator

[Opie]

You may also want to try the similar threads found at the bottom of this page. V V V

[domnita]

Thank you!

[andy.manninen]

Thank you Andy. I'll get my designer to try that.

Thanky!

Your Welcome! we are here to answer all your questions..... or at least try!

:Cheers:

P.S. post 100 on AUGI! (Too bad it doesn't count posts in CWC)

[rkmcswain]

Thank you!

When you start running into the limitations of OLE, you might want take a look at products like http://www.dotsoft.com/xl2cad.htm