I uploaded the image of the error and the word document. I left the excel sheet name as sheet1 (went back to it) because of the error, I figured the more alike they are the less chance of error. I passed this in the VBA Section and Under the macro section, just to try and make sure it was not me.
Quote:
Originally Posted by macropod
So what error message, if any, does the macro report?
I see, too, that you haven't changed the sheet name in:
StrWkShtNm = "Sheet1"
without that change, it isn't going to work.
|