Excel VBA for ammending outlook Signature template

Hi Need help,
Aim
I have a large number team and we all have different signatues ideally which is wrong. I am trying to create a Macro which will help others to set there signature as per standards.
Achieved yet
A new mail window opens up based on (.HTMLbody) it puts the signature in that mail. However
Need help on
Copy the signature from that mail & >>>update the signature template in the Signature folder "C:\Users\username\AppData\Roaming\Microsoft\Signatures".

So that it would be a 1 time process for a user that signature get saved in the HTML template. is this possible.

This will really be a big help for me

Regards
radish

I'm looking to do something very similar, but take the signature from a Word file and update the default signatures in outlook. Did you find a way to do this?

Thanks,
Dave