TheSwamp

CAD Forums => CAD General => Topic started by: JGupte on August 20, 2017, 10:12:32 PM

Title: AutoCAD Title Block from EXCEL VBA
Post by: JGupte on August 20, 2017, 10:12:32 PM

Hi All,

I am trying to write a VBA script that will run from inside an Excel spread sheet to update the title block fields from values in the spreadsheet.

I have been able to use ATTOUT to export the existing values to a TXT file and ATTIN to import the changed values. But I need to drive this from Excel VBA.
In plain English, what I need to do is:

Loop through all dwg files in a list
for each dwg file,
     find the Title block values in my spread sheet and export them to a txt file (in the correct format)
     open the dwg file
     import the txt file (ATTIN)
     save and close the dwg file
     Delete the txt file
Loop

I am fairly proficient in Excel VBA, but not in AutoCAD.
So far, I can create a link to AutoCAD and open the dwg file, then save and close it.

But I can't figure out how to automate the ATTIN function.

As I am not a Administrator on my PC (company policy) I can not install any programs of tools.

Any help would be appreciated.

JG

Title: Re: AutoCAD Title Block from EXCEL VBA
Post by: BIGAL on August 21, 2017, 12:42:23 AM

Check your post at Cadtutor also.