How do you change a macro path using Access 2013?
I was sent an Access 2013 database in email which I saved to my desktop. The database is supposed to pull Excel files in a folder and provide an output Excel file into a different folder. There is a macro which is supposed to do this. However, when I run the macro it provides an error (3011) that shows the very first file it attempts to find is not in a valid path. The path is pointing to the personal folder of the person who sent the database to me. I've received similar databases before and had no problems using them once saved to my computer.
How can I make Access recognize the path is now my own computer and not the previous user? I've tried editing the macro in design mode but see no option for pointing to the needed files.