Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automating Tables from VBA to AutoCAD

Status
Not open for further replies.

Amy_M

Programmer
Apr 13, 2022
1
US
thread707-1380592

Can anyone help me figure out how to copy and paste tables from excel into AutoCAD using VBA?
 
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,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
"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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top