Excel VBA to sort through AutoCAD Category .ATC files and re-browse GUIDS for tool palate elements based on name with new GUID
Pont is whe n you ahve AutoCAD Palette failes that need rebuilding oit creates a GUID to append to the file name of the palettes- This opens those files and re-browses the [FILEPATH]\[PaletteName]_[GUID36].ATC to use the [PaletteName] to browse for a new location and GUID attached to a new [palette name]_[NewGUID63].atc. Without it the images and everything falls apart... Attribute VB_Name = "AutoCAD_XML" 'open folder... \\corp.ktgy.com\global\Resources\Technology\Autocad\ktgy-2018\ToolCatalog\Categories ''for each file ATC KTGY-Annotation_398C94D2-3F40-44A9-A78F-C9060967DE2F.atc ''Regex find - Build dictionary ''<Url href= ''"\\corp.ktgy.com\global\Resources\Technology\Autocad\ktgy-2018\ToolCatalog\Palettes\Dimensions_3A32B23F-F3A1-4800-8A4A-046358939D5D.atc" ''/> ''For each member of dictionary ''If Filepath exists remove from dictionary '