ExpExchHelp
asked on
PowerPoint Default File Location
Experts:
In PowerPoint, how can I define both "default file location" and "default filename" through VBA.
I do >> NOT << want to use the "Tools | Options | General" to set the default location.
Essentially, the spreadsheet (.POT) would be used by multiple individuals... they all have to save it to the same location with the same filename (thus replacing existing files in the default subfolder).
Ideally, there would be a macro button on the slide (.POT) ... once clicked the content of the .POT would then be saved as an .PPT without them even having to specify name/location.
Also, once the .PPT has been saved, the command button/macro button should be removed from the .PPT.
Is that doable? If so, how can this be done via VBA?
EEH
In PowerPoint, how can I define both "default file location" and "default filename" through VBA.
I do >> NOT << want to use the "Tools | Options | General" to set the default location.
Essentially, the spreadsheet (.POT) would be used by multiple individuals... they all have to save it to the same location with the same filename (thus replacing existing files in the default subfolder).
Ideally, there would be a macro button on the slide (.POT) ... once clicked the content of the .POT would then be saved as an .PPT without them even having to specify name/location.
Also, once the .PPT has been saved, the command button/macro button should be removed from the .PPT.
Is that doable? If so, how can this be done via VBA?
EEH
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad I could help out!
How are you getting the command button to run the code though? It would only work in slide show view wouldn't it?
ASKER
@JSRWilson:
Correct... it only works in presentation mode. I'm ok w/ that though.
EEH
Correct... it only works in presentation mode. I'm ok w/ that though.
EEH
ASKER
Wow... that works fabulous!!!
Thousand thanks for the prompt response.
EEH