Quote Originally Posted by MOS MASTER
Hi Howard,

If the user has not alterd this path then it is by default %User%MyDocuments

But this no good for you because a user could have changed this and what about foreign languages....

Powerpoint is the least Robust Object model of them all and off course it doesn't provide what you want it to...(A simple Options.DefaultFileLocation = "bla")
That would be to easy.....

If you're up for it then you can off course to you're API Call thing on this challenge (To the options dialog) but there are Two Caveat'sI can think off)
* Language
* Office 97 the file box is on the Advanced tab (>97 the box is on the Save tab)

Don't envy you doing that.....

Another possibility is going into the registry and deal with the sucker over there...(not for everybody....be carefull for whome it concerns)

It's just a guess but PP most hold that value somewhere normaly it's in the registry. (Not shure)

I'll do a search for you later if there are better options!
Best option is the registry, that's easy to do.
But I've decided to just use App.Path in VB 6 for my sample code that sets the VBA passwords.

Too much trouble to hop around when testing if a different directory were to be used for Access, Excel, Powerpernt and Word. Haven't decided yet whether to add Outook.

The password code is common to all, but there's a different front-end for each app, each in a separate command button's code. Just needs a short front end for Outlook.

Oh well, I've been "awake" for about 26 hours, my stomach is growling, gotta eat then try to find my bed.