Hi everyone
I am looking for a program Lisp or VBA to draw boreholes (CPT) logs from Excel file in AutoCAD!?
Thank you in advance for helping me.
A program to draw boreholes (CPT) logs from Excel file in AutoCAD!?
That's a pretty specific request. I've never seen anyone doing such work. Most likely, you're going to have to do it yourself I'm afraid.
Ed
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.
If you do it, I suggest you do it with .NET API rather than VBA. A bit of unfortunate, Acad2025's .NET API just transit from .NET Framework to .NET 8, which is a compatibility-break change, you would have issue of supporting pre-Acad2025 versions and/or Acad2025. Still doing it with .NET API would be better option on the long run for this type of programming effort.
If you really can do it with minimum UI (because of 64-VBA's limitation), do it inside AutoCAD VBA, rather than do it from Excel VBA via COM automation.
@norman.yuan wrote:
If you really can do it with minimum UI (because of 64-VBA's limitation), do it inside AutoCAD VBA, rather than do it from Excel VBA via COM automation.
I agree with @norman.yuan The bulk of the work is with AutoCAD entities. You only need to read some input from Excel from within acad. And you can do that in NET or VBA.
Ed
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.
That's the reason why we learned how to program, so we could solve our own problems and be better, more efficient. Although, we help out with samples and fixing other's code, it often takes too much time to do something from scratch. There are programmers that hire themselves out. But you need to be able to fully describe what you want your app to do and how it should be done.
Ed
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.
If you are looking for "read-to-use" program, this is probably not the place for that. If you have a similar program with source code, and you are able to or try to modify/update certain lines of them, you can ask in this forum.
If you do not program, then, you either find existing program that does the exactly what you want (it is almost impossible), or take whatever the existing program does. Or, very likely, if enhance the productivity is mission-critical to your business for that kind of drafting work, it is worth to hire a capable programmer does it for you (well, it is also quite hard to find really good CAD programmer!). I'd say a task as you wanted would take at least a couple of weeks, or a full month, or long to be fully developed, which would cost you a few thousands to start with. But consider the productivity enhancement - manual drafting for a full day, or two, becomes a few seconds (maybe a couple of minutes, say the user has to select and open the correct data sheet and click the "Go" button").
If you do not program, then, you either find existing program that does the exactly what you want (it is almost impossible), or take whatever the existing program does. Or, very likely, if enhance the productivity is mission-critical to your business for that kind of drafting work, it is worth to hire a capable programmer does it for you (well, it is also quite hard to find really good CAD programmer!). I'd say a task as you wanted would take at least a couple of weeks, or a full month, or long to be fully developed, which would cost you a few thousands to start with. But consider the productivity enhancement - manual drafting for a full day, or two, becomes a few seconds (maybe a couple of minutes, say the user has to select and open the correct data sheet and click the "Go" button").
