none
How to find with VBA the directory where MS Project stores its Templates ? RRS feed

  • Question

  • Hi,

    How to find with VBA the directory where MS Project stores its Templates ?

    The following function returns an empty folder:

    CreateObject("wscript.shell").SpecialFolders("Templates")

    Thanks

    Monday, October 3, 2016 3:59 PM

Answers

  • Hi,

    since version 2013, Project templates are not longer forced to be saved in a specific folder, but users can select their favorite folder. See Ben's article http://www.applepark.co.uk/project-2013-template-mysteries-unravelled/

    Unfortunately, I am not aware of a way to read this settings in File - Options - Save. I only know how to change by code: OptionsSave(DefaultSaveFormat, DefaultProjectsPath, DefaultUserTemplatesPath, DefaultWorkgroupTemplatesPath, ExpandDatabaseTimephasedData, AutomaticSave, AutomaticSaveInterval, AutomaticSaveOptions, AutomaticSavePrompt, SetDefaultsDatabase)

    Perhaps you can make use of this method to get what you need in some way?

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by WLID1966 Tuesday, October 4, 2016 6:22 PM
    Tuesday, October 4, 2016 5:51 PM
    Moderator

All replies

  • Hi,

    since version 2013, Project templates are not longer forced to be saved in a specific folder, but users can select their favorite folder. See Ben's article http://www.applepark.co.uk/project-2013-template-mysteries-unravelled/

    Unfortunately, I am not aware of a way to read this settings in File - Options - Save. I only know how to change by code: OptionsSave(DefaultSaveFormat, DefaultProjectsPath, DefaultUserTemplatesPath, DefaultWorkgroupTemplatesPath, ExpandDatabaseTimephasedData, AutomaticSave, AutomaticSaveInterval, AutomaticSaveOptions, AutomaticSavePrompt, SetDefaultsDatabase)

    Perhaps you can make use of this method to get what you need in some way?

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    • Marked as answer by WLID1966 Tuesday, October 4, 2016 6:22 PM
    Tuesday, October 4, 2016 5:51 PM
    Moderator
  • Very interesting Barbara,

    Thanks a lot!

    Tuesday, October 4, 2016 6:22 PM
  • Hi,

    by the way: if user does not change folder, it is C:\Users\Barbara.Henhapl\AppData\Roaming\Microsoft\Templates, but special folder is referring to C:\Users\Barbara.Henhapl\AppData\Roaming\Microsoft\Windows\Templates

    Regards
    Barbara


    To increase the value of this forum, please mark the replies that helped to solve your issue as answer. If you find answers to questions from other forum participants to be helpful, please mark them as helpful. Your participation will help others to find an appropriate solution faster. Thanks for your support!

    Tuesday, October 4, 2016 6:26 PM
    Moderator