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 Mike Lewis 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
- Thread starter Amy_M
- Start date
SkipVought
Programmer
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]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my OLD subtlety...
for a NUance!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [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!
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]
Just traded in my OLD subtlety...for a NUance!
[/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
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
This might be useful as well:
- Status
Similar threads
- Locked
- Question
- Locked
- Question