embedded autocad object in excel

[johnbortoli]

i have previously inserted an autocad 2002 drawing in excel by using the insert object method in excel. Now that i have upgraded to autocad 2004 when i try to edit these spreadsheet drawing objects in acad 2004 i keep getting an error saying that excel cannot open the source application for this object. The procedure still works in 2002. any cluse on this one most appreciated

[Jon Fleming]

Highlight the drawing in Excel and change:

EMBED("AutoCAD.Drawing.15",...)

to:

EMBED("AutoCAD.Drawing.16",...)

No doubt this can be done automatically with a VBA macro, but I don't
know off hand how to do it.

[johnbortoli]

sorry but does not work. when i change the line as note i get the error "the text you entered is not a valid reference or defined name"

[Jon Fleming]

Hum.

Try inserting a new AutoCAD drawing and see what the formula bar lists it as? Then
change the old inserts to that?

[johnbortoli]

tried that.
When i go to insert object- autocad drawing, Excel lists it as =embed("autocad.drawing.16","") and returns the error
"cannot start the source application for this object"
even though autocad 2004 is open

[Jon Fleming]

It sounds as if the file association stuff in the Registry is damaged.
If AutoCAD 2004 has a "Repair" option in the installation, you might
try that; or uninstall and reinstall AutoCAD.
--
jrf
Autodesk Discussion Group Facilitator
Please do not email questions unless you wish to hire my services

In article

Post by johnbortoli
tried that.
When i go to insert object- autocad drawing, Excel lists it as
=embed("autocad.drawing.16","") and returns the error
"cannot start the source application for this object"
even though autocad 2004 is open

[workworkwork]

Have you found a solution? I am asking because I have the same problem with ACADlt 2004 embedded in Word and Excel 2002. I got the impression that Microsoft discontinued the support required to open the cad (security issue?) yet allow the file to be embedded.
Can anyone confirm this?

[adnan]

Try this, worked for me.
-
=EMBED("AutoCAD.Drawing","")
-