I have a MS Access application that needs to be deployed in over 300 different locations with varying computer systems. I therefore propose using SageKey to deploy the app to avoid configuration issues with other versions of MS Access. I therefore plan on saving the FE and BE of my app in one of the recommended locations for apps.
However my app requires the user to save a csv or xls file in a specific location.. The app looks in that folder and if it finds files it imports the data and moves the imported file to an archive subfolder. I thought it best to create a subfolder in My Documents with my app name where they could easily save the csv and xls files and a subfolder of that folder to act as the archive.
How can I reliably find the location of the My Documents folder using VBA? Or is there a recommended alternative approach to this situation?