Opening AutoCAD 2011 from Excel

[jkate]

My company has a spreadsheet in Excel that contains data and a macro for creating a drawing in AutoCAD. In previous versions of AutoCAD, the macro worked great. However, when trying to update the macro to communicate with AutoCAD 2011, it doesn't work, We get an error and when we click Debug, the line shown below is highlighted:

app = "AutoCAD.r19.DDE"
[highlight #FCE94F]chan = DDEInitiate(app, "System")[/highlight]

Can someone help in what might be causing this error and how to correct it?

Thanks.

 

[IRstuff]

Does "app" exist as written?

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[jkate]

I'm sorry IRstuff, I don't understand your question. What do you mean "Does "app" exist as written"?

 

[IRstuff]

app = "AutoCAD.r19.DDE"

Is that the correct app?

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[jkate]

I'm not sure if that's the correct app, and also don't where to find the correct app for AutoCAD 2011.

 

[IRstuff]

Can it really be that hard to find out your Autocad version number?

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529

 

[IDS]

If entering the correct version number doesn't fix it, try here:

http://autocad-2013-vba-enabler.software.informer.com/

That page also has a link to AutoCAD-2011-vba-enabler, so presumably there are some things that need enabling.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[jkate]

It's not the AutoCAD revision that I don't know. We're using AutoCAD release 2011. It's the DDE topic name for AutoCAD release 2011 that I don't know and don't were to find it. From what I understand, the DDE topic name is different than the actual Software name.

 

[IRstuff]

Have you heard of a wonderful new internet search tool called Google

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529