Just incase someone has a similar issue in the future I ended up extracting the extension from the instance name, and then adding the extension onto partnumbers with periods in the name when saving. It's kinda messy but It seems to work fine.
Dim GetExtension as String
GetExtension =...
Hello everyone,
This is my first thread on here, I'm having some issues with a seemingly simple part of a macro I'm working on.
Just as a bit of background, I'm modifying an existing internal macro that replaces certain segments of our part/product names to reflect a new code for that design...