Script to add many Data Links without using the Data Link Manager

[akyc115]

Hi,

Is there a way to add datalinks without doing it manually using the Data Link Manager?

 

I need to insert a lot of data links to a CAD file and was wondering if there is a way to streamline the process.

 

Excel Setup:

In my Excel workbook, I have many worksheets and each worksheet have 2 "Named Range" to be data linked in CAD. Does anyone know how I can do this?

 

If I had to add the data link manually, the step would be:

 

1) Data Link Manager > Create a new Excel Data Link

2) Choose an Excel File

3) Set Path Type: "Relative Path"

4) Select Excel sheet to link to: "Worksheet Name"

5) Link to a named range: "Named Range"

6) Uncheck "Use Excel formatting"

 

Thanks so much!