I'm automating the use of AutoCAD with Excel.
I want to create a macro in excel which would generate a drawing file
from a given template (custom drawing). The drawing should have an
incrementing filename. (Ex. aaa.dwg, aab.dwg, aac.dwg) Each of the
drawings data will come from the data in excel.
For example, I want to generate the first drawing.
I will input the data in excel. When the macro is triggered,
the first drawing file will be created by copying a template
and by updating the link (with the use of paste special, worksheet).
Then if I want to create another drawing by changing the text/data
in excel, a new file will be created that can be accessed through
a single sheet in excel and its data will be the last data entered.
All files created should be saved in a directory/folder.
In a single sheet, the files created will all be listed and through it,
the drawing can be updated and be opened.
Any help will be great for a student like me.
Thank You very much to all who would like to help.
I want to create a macro in excel which would generate a drawing file
from a given template (custom drawing). The drawing should have an
incrementing filename. (Ex. aaa.dwg, aab.dwg, aac.dwg) Each of the
drawings data will come from the data in excel.
For example, I want to generate the first drawing.
I will input the data in excel. When the macro is triggered,
the first drawing file will be created by copying a template
and by updating the link (with the use of paste special, worksheet).
Then if I want to create another drawing by changing the text/data
in excel, a new file will be created that can be accessed through
a single sheet in excel and its data will be the last data entered.
All files created should be saved in a directory/folder.
In a single sheet, the files created will all be listed and through it,
the drawing can be updated and be opened.
Any help will be great for a student like me.
Thank You very much to all who would like to help.