We have a Word template that loads automatically at startup, regardless of which startup path they use. We accomplished this by changing the "StartUWord 2010 default location: StartUp" to the folder where they've stored our template in the Trusted Locations and then also making that template a Word Add-In Template. Some people use the C drive, some use D, some use AppData, so Application.Startuppath is working for us in figuring out which path they setup as their default Startup location.

I was hoping there was a way to do that in PowerPoint as well, but it doesn't sound like there is. I guess I'll have to do the IF statement and account for specific storage locations.