Optimizing already available macro by fixing run time errors

Hello,

I've written this macro to -

1. Copy the data from cell B17
2. Open an existing document on my computer.
3.Paste it in the existing document.
4. Save the document as a pdf.

****************************************************

Please Login or Register  to view this content.

**********************************************************
It is also throwing a few run-time errors like - Run time error 13 (Type mismatch) for Ln17.

Could you please help me achieve this?

Regards,
Anshul

Edit: code tags added to original post

You should get in the habit of explicity declaring variables. In this case, if you declare str1 as a string, it will prevent the "Type mismatch" error:

Please Login or Register  to view this content.

Please Login or Register  to view this content.