Print Page | Close Window

Making AutoCad Block work as Excel Spreadsheet

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=5702
Printed Date: 31.May.2026 at 22:28


Topic: Making AutoCad Block work as Excel Spreadsheet
Posted By: linhoreka
Subject: Making AutoCad Block work as Excel Spreadsheet
Date Posted: 15.Apr.2011 at 13:49
I am developing an application look somehow like this:

http://www.youtube.com/watch?v=ZPqcwg0lzJo&feature=player_embedded" rel="nofollow - http://www.youtube.com/watch?v=ZPqcwg0lzJo&feature=player_embedded

http://www.youtube.com/watch?v=OI977Qw2G-4" rel="nofollow - http://www.youtube.com/watch?v=OI977Qw2G-4

The idea is making dynamic block act as a design spreadsheet (like Microsolf Excel):
1. You create the block with attributes as variables
2. You add your custom formulas to the block with a text editor.


Then, everytime you edit an attribute, other attributes and the block's dynamic properties would change accordingly as the formulas executed.

Here is the 7cad Block Demo Version 2.0 Setup
http://www.mediafire.com/?0hrzdab76ce92yv" rel="nofollow - http://www.mediafire.com/?0hrzdab76ce92yv

I cannot find any supports here in Vietnam for my application. So if there is anyone interest in my application, please let me know and give me some advise. Then we can share the application once it is done !
Thanks in advance !

May 9th: Update information and setup could be found at  http://7cad.wordpress.com/7cad-block/" rel="nofollow - http://7cad.wordpress.com/7cad-block/


-------------
http://7cad.wordpress.com - AutoCAD lisps and VBA shared


Replies:
Posted By: Vladimir Michl
Date Posted: 15.Apr.2011 at 13:53
Hello, please look at the parametric functionality introduced in AutoCAD 2011 - most of the functions can be probably done by this.

-------------
Vladimir Michl (moderator)
ARKANCE - https://arkance.world" rel="nofollow - https://arkance.world - Autodesk Platinum Partner

Posted By: Premsingh75
Date Posted: 15.Apr.2011 at 14:10
Hi,

Can u give me soft copy of this.  at

premsingh75 at hotmail.com


-------------
dddeqe

Posted By: John Connor
Date Posted: 15.Apr.2011 at 14:30
A copy of what?  AutoCAD 2011?  That would be a "no-no" as far as AutoDesk is concerned.

If you are a student you can obtain a free copy of many of the programs AutoDesk has to offer.  Start with this link:

http://students.autodesk.com/


-------------
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>

Posted By: linhoreka
Date Posted: 15.Apr.2011 at 16:29
I would finish the demo version setup in the end of this month. Then I would upload it for everyone.
Have you see my video ? I think it is different from the "parametric constraints". But once the "parametric constraint" and my application work together, I think we would be able to create more "Dynamic" block


-------------
http://7cad.wordpress.com - AutoCAD lisps and VBA shared

Posted By: John Connor
Date Posted: 15.Apr.2011 at 16:49
I'm sorry to say that "No, I have not seen your video."  If what you say is true I'm sure there will be many AutoCAD users interested in what you have developed.  Good luck.

-------------
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>

Posted By: Premsingh75
Date Posted: 16.Apr.2011 at 10:03

Dear John Ji


I am working, not a student . John I want to learn BBS (Bar Bending schedule) on Autocad with help of Rebar software. I c video link below. Can u help me Dear. I need softcopy of that file(show in video).

 

http://7cad.wordpress.com - AutoCAD lisps and VBA shared



-------------
dddeqe

Posted By: linhoreka
Date Posted: 16.Apr.2011 at 11:43
Here is the demo version  http://www.mediafire.com/?0hrzdab76ce92yv" rel="nofollow - http://www.mediafire.com/?0hrzdab76ce92yv
I would make the tutorial video as soon as possible. Thanks for your support. It make me feel up after a long time I have been working quite alone in Vietnam developing my idea.

Sunday: and here is the video of 7cad Block demo:  http://www.youtube.com/watch?v=OI977Qw2G-4" rel="nofollow - http://www.youtube.com/watch?v=OI977Qw2G-4


-------------
http://7cad.wordpress.com - AutoCAD lisps and VBA shared

Posted By: linhoreka
Date Posted: 20.Apr.2011 at 12:16
Link for Rebar Schedule application, written in VBA 
http://www.mediafire.com/?faui9chq1i1iu05" rel="nofollow - http://www.mediafire.com/?faui9chq1i1iu05
It works like this:
http://www.youtube.com/watch?v=Fw0gs8CCw98" rel="nofollow - http://www.youtube.com/watch?v=Fw0gs8CCw98

The command is TKT (Vietnamese command :) ) and ED to edit the block attributes



-------------
http://7cad.wordpress.com - AutoCAD lisps and VBA shared

Posted By: linhoreka
Date Posted: 22.Apr.2011 at 14:47
Whoops, does this application work ? Can the functions perform by my application be done by AutoCAD 2012 parametric functionalities ?

-------------
http://7cad.wordpress.com - AutoCAD lisps and VBA shared

Posted By: linhoreka
Date Posted: 09.May.2011 at 13:40
Update information and setup might be found at  http://7cad.wordpress.com/7cad-block/" rel="nofollow - http://7cad.wordpress.com/7cad-block/

-------------
http://7cad.wordpress.com - AutoCAD lisps and VBA shared


Print Page | Close Window