hi

[jshr]

I want to develop one application in vb which ll access data from excel n it ll gives some output in autocad (which is like tree structure.)

for developing such application which API i have to use??
or how to develop application using VBA editor in autocad 2004??

[RobDog888]

Welcome to the Forums.

Thread Moved

What version of VB? VB 6 or VBA 6.3?

[westconn1]

from VBA in autocad you can create an object to automate excel
do a search for late binding or look at robdogs tutorials and faqs

[dea412]

Welcome here, hope you success

[jshr]

Welcome to the Forums.

Thread Moved

What version of VB? VB 6 or VBA 6.3?

I am using vb 6.0 n autocad 2004...

[RobDog888]

I dont have autocad but can you explain more on this "data from excel n it ll gives some output in autocad "?
What output?

[jshr]

I dont have autocad but can you explain more on this "data from excel n it ll gives some output in autocad "?
What output?

suppose i want to draw one line in autocad for that i want to develop one application in vb 6.0 or i can use VBA editor in autocad 2004 for drawing that line. but the (parameters of line) point1 n point2 values i want to take from excel sheet...

how to develop such app??

this is small part of my project i explained you..

[RobDog888]

Yes, you will probably want to use Autocads VBA then. You should search its help file for nything on its VBA supportted functions and methods, looking for something that would look like a draw line function.

To connect to Excel from Autocad VBA would be the same as connecting to Excel from VB 6 or any other Office app to Excel. Add a reference and create your application object, open the desired xls file and read in your data.

[jshr]

Yes, you will probably want to use Autocads VBA then. You should search its help file for nything on its VBA supportted functions and methods, looking for something that would look like a draw line function.

To connect to Excel from Autocad VBA would be the same as connecting to Excel from VB 6 or any other Office app to Excel. Add a reference and create your application object, open the desired xls file and read in your data.

but i there is no add references option in VBA autocad 2004.so i m not able to add excel library.. then how do i connect app with excel??

[westconn1]

but i there is no add references option in VBA autocad 2004.so i m not able to add excel library.. then how do i connect app with excel??

do a search here for latebinding to create an object

[RobDog888]

Although this is for VB6, it still applies the same when you use it in Autocad VBA.
http://vbforums.com/showthread.php?t=406640

[jshr]

Although this is for VB6, it still applies the same when you use it in Autocad VBA.
http://vbforums.com/showthread.php?t=406640

no it is not working in Autocad VBA....

[RobDog888]

You need to be more descriptive then "it doesnt work".

Using Late Binding as in my examples it will work.