TheSwamp
CAD Forums => CAD General => Topic started by: Zykl0 on May 12, 2009, 09:19:06 AM
-
Hello,
I am trying to figure a way to take data from .xls files and update Mtext or Attribute in my layout.
Like most programming language do with .ini files.
What i am trying to do is creating a Master file in excel for each future project, and filling every needed cell like;
adress1, adress2, contractor, and other usefull informations.
I'm on AutoCAD 2007 Actually and maybe 2010 if i can find some argument to convince my boss.
Thanks
-
Me thinks you will be happier trying to perform this function with FIELDS, and Sheet Set Manager. (no upgrade required)
-
Me thinks you will be happier trying to perform this function with FIELDS, and Sheet Set Manager. (no upgrade required)
i tired the Field earlier but i cant find anything usefull with this
Tried with hyperlink, loaded excel file, and everything i see is the path of the excel file in mtext (not that useful :( )
-
Did you try using Sheet Set Manager, and Fields together?
I am not saying that you can link this to your client/project XLS file, however one need only enter this data once for the client/project, and then one can use current or previous sheet sets as a template for the next set of sheets(job).
Someone here might have a way to edit the DST file and create the sheet set files with VBA or other program.
-
I use fields and custom properties, also I wrote a little routine to save the data in an SQLite database.
You can probably find something to query an XLS file to populate the fields