Quote Originally Posted by RaghavendraPrabhu View Post
...
One small question please. How do I modify the macro to use a template named template.xlsm placed within a folder in the same folder instead of creating a xlsx file?
https://stackoverflow.com/questions/...-a-column?rq=1
The path were the template is, is ThisWorkbook.Path & ""Template”\”Template.xlsm.
I am not sure exactly what you are asking here. I am not too familiar with the code you referenced at the stack overflow Forum.
If we are talking about the code, Sub ExportByName(), then it does not make a file if it already exists.
If you always have a file ready at the specified location, then no new file will be made.

Possibly you are asking for when you have no file for a team Member, then rather than make a new one, you open the template and save that with the missing team member file.?

If that is your question, then you would remove
Workbooks.Add
and replace that with coding to open that template file, and then save it with the name for the new member, but remember to save it at the correct File path, which I assume would still want to be that for where the master file is.

If you need more help on that modification then let me know.

Alan