Insert Multiple Blocks

[gerrykroberts]

Hi all,
I'm new here and also in VBA so i need somebody's help.
I have an Excel spreadsheet with X, Y and Z data of some point (approximately 5000).
I need a code in order to put a block, that it is being inserted in the drawing, in the above point x and y whose text it will be the information from the third column of the Excel file (z-coordinate).
Any thoughts would be appreciated.

Gerry

[Anonymous]

Addressing the individual steps will make it easier for you.
This is a good project to learn on. Each step has been
discussed in the group on many occasions.

Start simple
- First get confortable using VBA itself. Won't take long.
Get a good book "VBA Developers Handbook" or
many others.

- Then learn how to insert a block and set it's attributes.
I assume you mean attributes "whose text..."

- Once you're confortable - now look into Automating
Excel from AutoCAD - Many samples on this in
this group and others. The code will look very similar
to coding in Excel VBA as far as reading your range
values and iterating the spreadsheet. If you haven't
done any excel vba - I would start there so you don't
have to worry about Automation at first. Bunch of
turorials on the net about using Excel via VBA.

- Also - there are samples right in the AutoCAD help system on
Automating Excel from AutoCAD and vice versa.

- Get started and post back if you need help with the individual
steps.


wrote in message news:5395042@discussion.autodesk.com...
Hi all,
I'm new here and also in VBA so i need somebody's help.
I have an Excel spreadsheet with X, Y and Z data of some point
(approximately 5000).
I need a code in order to put a block, that it is being inserted in the
drawing, in the above point x and y whose text it will be the information
from the third column of the Excel file (z-coordinate).
Any thoughts would be appreciated.

Gerry

[Anonymous]

I agree with Paul, but sometime when
you have a time limit better yet to see the
similar solution, IMHO
Here is something that will be helps I hope
See attached file here

http://www.cadtutor.net/forum/showthread.php?t=10132

Fatty

~'J'~