Reply to thread

Message: [QUOTE="ttp, post: 2008222"] I have an Excel spreadsheet that is updated weekly. Weekly, new records are added to the file that need to be compared to a data file in Access. Since the file is changed weekly, I want to prompt the user to provide the file name that needs to be linked to the Access database so that the queries and assessments can be performed. But, I don't know how to write code to prompt for this information. I believe that maybe I can write a module anc macro to accomplish this. But, my experience with Access is very limited beyond creating databases and queries. Can a module be written to accomplish this? Or can anyone recommend a web site that will provide insight on how to accomplish this? Any assistance would be appreciated. Thanks in advance. [/QUOTE]