Update Hyperlink Path in Blocks from XLS

[thaydenCJMLL]

I have a task to update hyperlinks in a block definition (DetailBubble).

I'd like a tool to search a drawing and it will reference an XLS file to find the new, correct path to assign to that block insert.

The mapping logic is based on the values of 2 known attributes in that block definition, and when the 2 correct pairs are found, the hyperlink is updated in that block from the spreadsheet.

I know how to do this for standard attributes - but working with hyperlinks paths is new to me.  I found a few ideas online, but one uses a 3rd party VLX  freeware tool from a website that my company has blocked.

Is this possible? I wasn't even able to extract the hyperlink paths using the Data Extraction Wizard...

Sample DWG with 2 blocks and the corresponding sample mapping xls is attached.

I've removed real links from the blocks - and back-filled with dummy links for example.

[paullimapa]

perhaps the discussion on this post will give you some ideas on how to retrieve and apply hyperlinks?

https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/lisp-to-grab-text-hyperlink-and-inse...

[Moshe-A]

@paullimapa ,

thank you Paul 😀