Hopefully this is an easy question- I just need to be pointed to the right command.
I have a database that needs to regularly import spreadsheets (they are already formatted correctly). I will be handing this database off to the folks here when I leave, and am trying to automate it as much as possible so that the non-Access folks (not that I am a programmer, but I know the basics fairly well) will be able to use it without any problems at all.
I could use DoCmd.TransferSpreadsheet to import a file with an input box to ask for a filename and location. However, the people who will be using this database probably won’t remember the name of the file they just created, nor will they know the path through the network to find where it is located. I can’t make it a standard location, as depending on the user and month the directory will change. Is there an easy way I can bring up the standard file locating browse window or dialogue box and pass the name/loc on to TransferSpreadsheet?
Thanks,
Rhythmdvl