Add Approved Stamp to PDF from Excel VBA

[coolkiran]

Hi All

i got a macro code, which will open PDF and put a stamp in PDf.

i need to add "Approved" stamp, but the macro is adding "Draft" Stamp.

I have attached the vba code.

Any suggestion which will add "Approved" stamp?

 

[coolkiran]

Any suggestion.

 

[coolkiran]

Is that possible to do it, or i have to do manually?

 

[Safwan]

can you please advice me regarding above Excel sample files