I have a series of Microsoft Office 2010 templates (Excel, PowerPoint and Word) spread through a pre-defined folder hierarchy.
I need to make sure that when a new document is created from one of those templates, it defaults to saving it in the same folder as the template it was created from.
I was able to accomplish the task for Word using a macro such as
Sub AutoNew()
ChangeFileOpenDirectory ActiveDocument.AttachedTemplate.Path
End Sub
but I had no success in replicating this behavior in Excel nor PowerPoint.