Hi Dexter,

Thanks for your response. I have tried the macro and unfortunately its not working for me, instead I get a "Run-time error '429'. ActiveX component can't create object.

I researched how the above error could be resolved but alas, everything I've tried so far hasn't worked.