https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818039#M29969 Addressing the individual steps will make it easier for you.<BR /> This is a good project to learn on. Each step has been<BR /> discussed in the group on many occasions.<BR /> <BR /> Start simple<BR /> - First get confortable using VBA itself. Won't take long.<BR /> Get a good book "VBA Developers Handbook" or<BR /> many others.<BR /> <BR /> - Then learn how to insert a block and set it's attributes.<BR /> I assume you mean attributes "whose text..."<BR /> <BR /> - Once you're confortable - now look into Automating<BR /> Excel from AutoCAD - Many samples on this in<BR /> this group and others. The code will look very similar<BR /> to coding in Excel VBA as far as reading your range<BR /> values and iterating the spreadsheet. If you haven't<BR /> done any excel vba - I would start there so you don't<BR /> have to worry about Automation at first. Bunch of<BR /> turorials on the net about using Excel via VBA.<BR /> <BR /> - Also - there are samples right in the AutoCAD help system on<BR /> Automating Excel from AutoCAD and vice versa.<BR /> <BR /> - Get started and post back if you need help with the individual<BR /> steps.<BR /> <BR /> <BR /> <GERRY1> wrote in message news:5395042@discussion.autodesk.com...<BR /> Hi all,<BR /> I'm new here and also in VBA so i need somebody's help.<BR /> I have an Excel spreadsheet with X, Y and Z data of some point <BR /> (approximately 5000).<BR /> I need a code in order to put a block, that it is being inserted in the <BR /> drawing, in the above point x and y whose text it will be the information <BR /> from the third column of the Excel file (z-coordinate).<BR /> Any thoughts would be appreciated.<BR /> <BR /> Gerry</GERRY1> Tue, 14 Nov 2006 16:04:20 GMT Anonymous 2006-11-14T16:04:20Z https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818038#M29968 Hi all,<BR /> I'm new here and also in VBA so i need somebody's help.<BR /> I have an Excel spreadsheet with X, Y and Z data of some point (approximately 5000).<BR /> 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).<BR /> Any thoughts would be appreciated.<BR /> <BR /> Gerry Tue, 14 Nov 2006 11:34:27 GMT https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818038#M29968 gerrykroberts 2006-11-14T11:34:27Z https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818039#M29969 Addressing the individual steps will make it easier for you.<BR /> This is a good project to learn on. Each step has been<BR /> discussed in the group on many occasions.<BR /> <BR /> Start simple<BR /> - First get confortable using VBA itself. Won't take long.<BR /> Get a good book "VBA Developers Handbook" or<BR /> many others.<BR /> <BR /> - Then learn how to insert a block and set it's attributes.<BR /> I assume you mean attributes "whose text..."<BR /> <BR /> - Once you're confortable - now look into Automating<BR /> Excel from AutoCAD - Many samples on this in<BR /> this group and others. The code will look very similar<BR /> to coding in Excel VBA as far as reading your range<BR /> values and iterating the spreadsheet. If you haven't<BR /> done any excel vba - I would start there so you don't<BR /> have to worry about Automation at first. Bunch of<BR /> turorials on the net about using Excel via VBA.<BR /> <BR /> - Also - there are samples right in the AutoCAD help system on<BR /> Automating Excel from AutoCAD and vice versa.<BR /> <BR /> - Get started and post back if you need help with the individual<BR /> steps.<BR /> <BR /> <BR /> <GERRY1> wrote in message news:5395042@discussion.autodesk.com...<BR /> Hi all,<BR /> I'm new here and also in VBA so i need somebody's help.<BR /> I have an Excel spreadsheet with X, Y and Z data of some point <BR /> (approximately 5000).<BR /> I need a code in order to put a block, that it is being inserted in the <BR /> drawing, in the above point x and y whose text it will be the information <BR /> from the third column of the Excel file (z-coordinate).<BR /> Any thoughts would be appreciated.<BR /> <BR /> Gerry</GERRY1> Tue, 14 Nov 2006 16:04:20 GMT https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818039#M29969 Anonymous 2006-11-14T16:04:20Z https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818040#M29970 I agree with Paul, but sometime when<BR /> you have a time limit better yet to see the<BR /> similar solution, IMHO<BR /> Here is something that will be helps I hope<BR /> See attached file here<BR /> <BR /> http://www.cadtutor.net/forum/showthread.php?t=10132<BR /> <BR /> Fatty<BR /> <BR /> ~'J'~ Thu, 16 Nov 2006 15:53:17 GMT https://forums.autodesk.com/t5/vba-forum/insert-multiple-blocks/m-p/1818040#M29970 Anonymous 2006-11-16T15:53:17Z