Confused about calculations

Hello – I’ve seen what I think might be answers to my questions but don’t understand the answer or where/how to use it. I have several line lengths (i.e. conduit) and would like to have AutoCAD display the total off all my conduit lengths. Then I would like to take that total and multiply it by the quantity of wires I have running through it. I suppose from what I’ve seen I would need some type of VB or LISP routine. I don’t know what that is, how to enter it, or where it would output the information. I would like it to populate an Excel file that I’ve inserted into AutoCAD. I would need it to dynamically update the file when I make a change to the conduit length. As an example: I may have a conduit run 15’, that has (2) #10’s and (1) CAT5, it may lead to a run that has (8) #10’s and (2) CAT5 already. My goal would be to find out the length of cable I need of each type based on the distance of the run, and just the length of the conduit. I would be happy if I could just export the conduit length to an Excel file where I can do the additional calculations.
Do any of you have a suggestion? I would greatly appreciate it or a resource to turn to. Thank you.

 

Hi James,

Use you Windows Explorer to search for files with an Extension of DVB. You
will find one with names implying linkage to Excel, such as ExcelLink.dvb,
or Excel-Sample.dvb

Drag the file into the AutoCAD drawing graphic area.

Type VBAIDE at the AutoCAD command prompt.

Look for the word SUB with the internal search feature. You can then press
the F8 key and step through the process. You will find it is set up to
exchange data between Excel and AutoCAD. All you need to is modify it to
meet you specific needs.

Spend some time looking at the code and where you are unsure of something -
select the word with the mouse and press F1 to get help about the word.

--

Regards,


Laurie Comerford
www.cadapps.com.au

 

Thanks you for the start. I can get to the VB window and can see that there’s code, and even a button somewhere in there; but how do I make it work? Where do I enter what I would like it to do? Do I need to give the excel db a name before I do something here? Thanks

 

Hi James,

Look for the word SUB with the internal search feature. You can then press
the F8 key and step through the process.

To go further you should study the user interface and the pull down menus
and Icons.

--

Regards,


Laurie Comerford
www.cadapps.com.au