code ?

Hello everyone
I'm looking for program code (lisp or vba) which can be used to attach
data from an Excel table(catalog products), with autocad entities, and
to be able to extract them afterwards in another Excel table or access
database (list for purchase order), I'm looking for code or an
application's name developed for this need…

Thank you

 

Hi media,
I dont know of any specific Applications for your needs. Lots of code
though.
All you have to do is learn VB.

However if its truly something you feel
strongly about I would be more than willing to Write the code for you.
For a reasonable fee. If you want you can contact me at

Or if you choose to do it yourself you can go to http://vbdesign.net
and get help with code.
If this is your first project you can figure about 6 months nights and
weekends to learn
enough to make it happen. Good luck and happy codeing


--
allfro - Chaos Coder Extraordinaire

'site index' (http://www.vbdesign.net/) | please use [ vbcode]
\"your_code_here\" [/vbcode ] code tags | be nice | 'augi'
(http://tinyurl.com/ytk37) |'go babelfish' (http://tinyurl.com/2j7df)

 

Do a full install of your AutoCAD and then look in the Samples\VBA and
directory. There you will find two xmples of what you want to do - here are
their descripttions right out of the help file:

-attext.dvb: This sample extracts data from a drawing and puts the data
into Microsoft® Word and Microsoft® Excel files. This sample requires
Microsoft® Office 97 or Microsoft® Office 2000. Before using this sample,
open the attrib.dwg sample drawing file in the ExtAttr directory. To use
the sample, run the macro named Extract_Dialog.

-ExcelLink.dvb: This sample creates an Excel workbook that contains a bill
of materials (BOM) for the current drawing. After the BOM has been edited
in Excel, the data from the workbook can be passed back into the drawing.
This sample requires Microsoft Office 97. Before using this sample, open
the attrib.dwg sample drawing file in the ExtAttr directory. Before
updating a drawing, make the workbook with the BOM active.

As for allfro's offer, I would wonder about someone who isn't even aware of
the samples Autodesk provides

___________________________
Mike Tuersley
CADalyst's AutoCAD Clinic
Rand IMAGINiT Technologies

 

SmartLister will allow you to attach data to any object in ACAD and export
it to csv or mdb. You may also want to look at the code in developer help
that attatches and retrieves xdata in addition to the other mentioned code
snippets.

--
David Wishengrad
President & CTO
MillLister, Inc.
Software for measuring and stretching multiple 3D solids.
Http://Construction3D.com

 

Media,
I have been Programming VB6 & AutoCAD for about 3 Years and am well
aware of all the samples provided in the Autocad full install. It has
been my experience that their are as many ways to write an Application
as thier are People that want them written. (The only reason I offered
to write it for you)
Yes their are lots and lots of examples.
However making those examples play nicely togeather and do what you
want will constitute a program at least if not an Application.
Otherwise you will need to have several macros to each do 1 specific
task. As I said before just come on over to
http://vbdesign.net/expresso/ and get all the help you need if you want
to do it yourself. Ill be glad to help.
As you will soon enough find out the examples AutoDesk provides will
rarely do exactly what you want them to do.

Personaly I would wonder about people that make derogatory statements
about people they dont even know just so they can feel better about
themselves.


--
allfro - Chaos Coder Extraordinaire

'site index' (http://www.vbdesign.net/) | please use [ vbcode]
\"your_code_here\" [/vbcode ] code tags | be nice | 'augi'
(http://tinyurl.com/ytk37) |'go babelfish' (http://tinyurl.com/2j7df)

 

Mike (and anyone else who cares)

I can assure you, there is no reason to doubt either Allfro's ability
or the sincerity of his offer to help. He may not be that familiar to
people here, but he is very well known among the members of the
expresso community at vbDesign. You would do well to encourage his
participation here.

 

My humblest apologizes, then, allfro The point to sfidler was you never
know who you are talking to here - especially one who offers to customize
first instead of pointing to an in-place example. Granted the examples
leave some room for improvement, but the novice can learn from them.
Obviously, per Chuck's post, I am in error and apologize!

Mike
__________________________
Mike Tuersley
CADalyst's AutoCAD Clinic
Rand IMAGINiT Technologies