Replace Macro's value

[abcdetech]

I have a Macro which stores a FileName.

For example FileNameMacro = FileName.dll or FileName.exe

I want to replace file extesnion in the macro

for example Macro should look like

FileNameMacro = FileName.pdb

in other words I want to replace .exe or .dll with .pdb in the Macro

thank you