AutoCAD 2010/2011/2012 DWG Format

[#1]

I had been generating my BOM manually in Excel, counting part numbers up from a drawing.  I have written an Excel Macro to help me get the data exactly how our purchaing department wants it, after I have it entered.  I am now using AutoCAD to count leaders to create my BOM, can I use the macro's i have written in Excel in AutoCAD instead to manipulate the data the way I want in a table?  I can export the table to Excel, run the Macro, then import it back to AutoCAD, but this takes some time.  If I could do away with this step and just run my Macro right from AutoCAD it would be a huge help. 

Thanks,

Alan

[#2]

Hi,

basically you can develop (nearly) all within AutoCAD. So the answer to your question could be: yes, ;

On the other side you have done some customization with Excel, but didn't tell us exactly what you did with Excel. E.g. have you used referenced sheets, have you used formulas within cells, have you used Macro-Recording, ...?

If you only used Excel-VBA to fill cells then you would also be able to use VBA (or better VB.NET) to fill an AutoCAD-Table-object. That needs working-time, but you will not receive to much unpleasent surprises.

Do you have referenced sheets then porting your Excel-VBA-code to AutoCAD is also possible, but you will have to calculate much more time to get it running.

Good luck, - alfred -