I looked but I couldn't find it. I am new to writing macros so if this has been answered I apologize. I have a workbook that has data that can only be updated by opening another source workbook so what I need to do is just that. When the excel file is opened, it automatically opens the source workbook which would let the original excel file be updated and then close out the source workbook and leave the original file open. I was able to find code that opens the source workbook immediately upon opening the workbook but it stays open and doesn't close. I'm guessing there is s simple line of code I am missing? Thanks for any help.