Combining Two VBA's Excel 2013

Hi, I need some help combining the two subs below. The first Sub ExcelRangeToWord has been placed in the sheet 1 tab and the Sub DocSearch has been placed in the This Workbook tab.

I would like both of them to run at the same time. Right now if you run the first one, it will open the specific Word document and copy the tables over. You then have to save and close the word document and run the second sub.

I would like them both to run and then perform a Save As to a different location so the original word document is untouched.

Thank you,
Colby

Please Login or Register  to view this content.

Please Login or Register  to view this content.

It works perfectly!

Thank you!
Colby

I actually have one more question.
Is there a way to do a save as to a variable from the Excel document? I want to avoid someone accidentally saving over previous work?

Would it be possible to pull from two cells within the Excel worksheet? On Sheet 1, from cells C1 and C5. C1 is a name and C5 is the date.

Thanks!

Once again, thank you!!

Colby