Results 1 to 5 of 5
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PPT paths (PPT 2000)

    In a Word template I can determine the Word startup path with<pre>Application.StartupPath</pre>


    In a Word template I can determine the Excel startup path with<pre>Dim xlApp
    Set xlApp = CreateObject("Excel.Application")
    Dim strStartupPath As String
    strStartupPath = strFixPath(xlApp.StartupPath)</pre>


    But for the life of me I can't determine Powerpoint's Addin path or template path, and seek help.

    I know they exist, because (ppt) saveAs template (*.POT) defaults to a suitable folder and (ppt) saveAs addin (*.PPA) defaults to a suitable folder.
    I can't find the relevant properties in the Powerpoint application.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PPT paths (PPT 2000)

    All Office applications share the same user templates and workgroup templates folders. If you try to save any Office document as a template (.dot, .xlt, .pot), the user templates path is the default proposed location. This can be retrieved in Word as

    Options.DefaultFilePath(wdUserTemplatesPath)

    The default add-in location is

    Cocuments and Settings<username>Application DataMicrosoftAdd-Ins

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PPT paths (PPT 2000)

    Thanks, Hans.
    So presumably the approach in <post:=348,046>post 348,046</post:> is preferable to my actually loading an application and using its Application properties to obtain the path?
    In Word I have used Tools, Options, File Locations to modify the Startup folder path, so using (Word) Application.StartupPath makes sense to me.
    Those options appear to be not available in other MSOffice applications.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PPT paths (PPT 2000)

    PowerPoint VBA is very limited compared with Word VBA and Excel VBA. The user templates path is not exposed directly, so you have to resort to other methods - obtain the path from the registry, or use Word or Excel.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: PPT paths (PPT 2000)

    > obtain the path from the registry,
    Right. It just isn't available, or at least, isn't exposed through the PPT application.
    (sigh!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •