I need a solidworks Macro for removing REV A for a part number

[CHerw180]

We currently are using 2023 Solidworks SP 1.0. We need a macro that can remove REV A from the file name and link that to a field on our drawing template. For example: We have a part and print save as HS2097 REV A where A can be any number or letter.