Calling PowerPoint (PP) from Access and saving file upon exit from

[Guest]

I can call PowerPoint, Word and Excel from Access. When exiting from these
called applications, I want to save the PowerPoint, Word or Excel file in a
predetermined location with a file name prefix that is a unique action
identifier on the Access form containing the call to PowerPoint, Word and/or
Excel. Before leaving the PowerPoint, Word or Excel application, the user
will be requested to provide a name that will be appended to the unique
action identifier and this will then be used as the file name. This will
result in grouping together all files created in support of the action.
These file names can be stored in a database and used as a hyperlink to the
files containing information related to the action.

I'm looking for help on how to code this feature or other recommnedations on
how this can be accomplished.

 

[Steve Rindsberg]

I can call PowerPoint, Word and Excel from Access. When exiting from these
called applications, I want to save the PowerPoint, Word or Excel file in a
predetermined location with a file name prefix that is a unique action
identifier on the Access form containing the call to PowerPoint, Word and/or
Excel. Before leaving the PowerPoint, Word or Excel application, the user
will be requested to provide a name that will be appended to the unique
action identifier and this will then be used as the file name. This will
result in grouping together all files created in support of the action.
These file names can be stored in a database and used as a hyperlink to the
files containing information related to the action.

I'm looking for help on how to code this feature or other recommnedations on
how this can be accomplished.

This may be too broad an answer, or too simpleminded (a specialty of mine,
that) but you'd call the .SaveAs method on the PPT presentation oject that
you've referenced. .SaveAs takes, among other parameters, a string that's the
full path + name of the file you want to save. You'd have to cobble up the
string in whatever manner suits your needs.

There's some further info about automating PPT here:
How to automate PowerPoint using VB
http://www.rdpslides.com/pptfaq/FAQ00115.htm

and in the surrounding FAQ entries. This refers to VB but the same code should
work from Access.