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!