Automating Tables from VBA to AutoCAD

[Amy_M]

thread707-1380592

Can anyone help me figure out how to copy and paste tables from excel into AutoCAD using VBA?

 

[SkipVought]

Welcome to Tek-Tips. You can learn a lot here. Check the FAQs.

Over the decades, I've used Excel VBA to access other application's Object Libraries and send and receive data between Excel and that application.

Have you added the appropriate library or libraries to VBA Tools>References?

Then how can you know what objects to use? You need to know something about object models in general and the object model for any application. Maybe there's a web site that you can find. That's a good start.

I found, in addition to all that, that the Watch Window was/is a great help in discovering what property to use in a particular instance.

faq707-4594.

Don't forget to post your specific questions here at Tek-Tips.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[Andrzejek]

I don't know AutoCAD, but I did work with MicroStation (Bentley product) which does have a VBA, like Excel, Word, etc. From MicroStation's VBA I could connect to a data base (Oracle) and get whatever data I wanted. I am sure I could do the same connecting to Excel.

So, you may want to check Mastering AutoCAD or Introduction to Visual Basic® for Applications for AutoCAD

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[strongm]

This might be useful as well:

https://www.augi.com/uploads/autodesk_university/2005/CP22-3.pdf