I have a little bit of experience working with macros in Excel. I am getting into work with AutoCAD LT 2010. I have just started so please bear with my lack of proper terminology or operating procedures. Right now I am just wondering if this is possible and if my line of thinking is along a good path or not.
I deal with making cutouts in foam that match the profiles of tools. Some tools can be turned and profiled different ways and the foam can also be cut to fit tight or loose to the tool so I can have a few profiles for each tool. I have a folder containing dwg's of tool profiles. Presently each file contains only 1 profile (object?) with text giving the tool number but I would like to have each file contain all profile views of each tool with text to go with each view. I think that the way to accomplish what I want with a macro is to have each profile on a different layer or maybe each profile should be at a specific x-y location. All files would have the same number of layers and all would be named the same or the x-y locations would be matched on all files. I think the layer system would be best but do not know enough yet to be sure. If I set up all files this way I am wondering if it is possible to
1. create a list in Excel
2. have the macro open the dwg's one at a time matching each tool number on the Excel sheet ( not all tools on the spreadsheet would have a matching file)
3 copy the profile from the proper layer, layer being determined by a value in a specific cell of the spreadsheet
4. paste all of the copied profiles onto 1 new CAD file, all on the same layer, moving each paste location a distance of say 6" to the right of the previous paste