A
Alexander Atzert
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.
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.