TheSwamp
Code Red => VB(A) => Topic started by: ruairiT on July 07, 2010, 01:53:49 AM
-
Hi,
I have the following query. I have been the task of finding out what possibilities exist and how much effort would be involved to do the following.
From an excel table where the user inputs several paramaters a diagram of a section through a tunnel is created (See screenschot attached)
What would be involved and how much effort would be required to get this resulting diagram reproduced/redrawn in Autocad and I don't mean as an OLE object.
Or would another approach be better in the sense of a completely new program just using VB or lisp. How complicated would this task be?
Thanks
Feargt
-
You can't create objects and use table cells as construction parameters. If you need to draw this, then indeed you need to program.
-
Thanks for the response, any ideas as to how complex a task that would be? Would it be bette to outsource the work?
-
If the drawing in the spreadsheet is dynamic and changes with the user input, then the calculations are already there, you would simply need to apply them to lisp, vba, or .net to make it a viable application.
You could outsource it for sure, something you might consider if your skills are not up to the task. There are many qualified and able programmers here, you just have to take your pick.
-
A easy way to do it from excel is using a script file.
You can use a column in the spreadsheet for the script commands, then copy/paste the data to a .scr file.
I have a command button and vb code in the spreadsheet to write the script file. Then use the autocad scr command read it in.