Hi there,
The code segment below is part of a larger sub which creates a copy of a template workbook and renames it under a staff name. The only way I've found to make it work on Sharepoint is by opening the Template workbook first, Saving As under a different filename, then Closing.
The...