Default File Locations (PowerPoint V2002/3)

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

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

Debug.Print CreateObject(“WScript.Shell”).RegRead(“HKCUSoftwareMicrosoftOffice11.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.

Reply | Quote