chellemokona2123
New Member
- Joined
- Apr 5, 2011
- Messages
- 1
I am trying to create a spreadsheet model that will assist a human resources manager with hiring decisions. Currently, I have "resumes" in Microsoft Word as the applications for a position. I want to be able to get the names of the applicants from the Microsoft Word file into the Microsoft Excel file.
Specifically, my idea is to have a separate worksheet for each applicant. I know how to add a worksheet to a workbook using VBA, but I am not sure if I am able to copy a phrase from Word (ex. "Mary Bobble") and add a worksheet with the applicant's last name as the worksheet name.
Specifically, my idea is to have a separate worksheet for each applicant. I know how to add a worksheet to a workbook using VBA, but I am not sure if I am able to copy a phrase from Word (ex. "Mary Bobble") and add a worksheet with the applicant's last name as the worksheet name.
