I am working on an Access application that will assist (require?) compliance with a file naming convention.
What I would like to be able to do is show the user a list box of all files he has open -- whether they be pdf, xls, doc, etc.
User would be able to select a file and certain portions of the filename 'string' would be automatically generated such as: J:\CustomerFiles\(file no)_(date)_[UserInputFileNameInfo] &(extension).
I've found some code that lists open applications (but couldn't get it to work). What I need is code that lists the open files.
Suggestions? (I've also seen some info on the possibility of using API -- but I have no idea how to use that or how to integrate it with Access.)
Thank you.
swtrader
What I would like to be able to do is show the user a list box of all files he has open -- whether they be pdf, xls, doc, etc.
User would be able to select a file and certain portions of the filename 'string' would be automatically generated such as: J:\CustomerFiles\(file no)_(date)_[UserInputFileNameInfo] &(extension).
I've found some code that lists open applications (but couldn't get it to work). What I need is code that lists the open files.
Suggestions? (I've also seen some info on the possibility of using API -- but I have no idea how to use that or how to integrate it with Access.)
Thank you.
swtrader
