Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Christchurch, New Zealand
    Posts
    250
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default File Locations (PowerPoint V2002/3)

    I want to tell VBA where the workgroup templates are stored using default file locations. (In Word - Options.DefaultFilePath(wdWorkgroupTemplatesPath) )
    I could hard code the path, but this could cause me problems as the addin will be used on a network with some citrix clients.

    Another question - Application.Username doesn't seem to be available. If I try and record going into the Tools, Options dialog nothing shows in my code either.

    Does anyone know if this is possible? I've been scrolling through PPT FAQ pages (and learnt a lot at the same time), but now am starting to get a headache. Any help will be greatly appreciated.

    Thanks.

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

    Re: Default File Locations (PowerPoint V2002/3)

    PowerPoint VBA is very limited in some respects. I would start an instance of Word through Automation to retrieve the workgroup templates path and username.

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

    Re: Default File Locations (PowerPoint V2002/3)

    You could also read the workgroup templates path from the registry:

    Debug.Print CreateObject("WScript.Shell").RegRead("HKCUSoftwar eMicrosoftOffice11.0CommonGeneralSharedTemplates")

    (11.0 is for Office 2003, use 10.0 for Office XP)

    Unfortunately, the MS Office username is a binary value, so it is not so easy to retrieve.

Posting Permissions

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